Sep 20, 2019 | Data Security, SQL Server, Web Applications, Web Development
By: Phillip Sharpless Security, as part of many projects, is all too often an afterthought. The standing up of a new system or the development of a new project can be quite rapid and dynamic. Not pausing during this process to think about security as an...
Aug 6, 2019 | SQL Server, Technical Information
By: Andy Kim Introduction The SELECT…INTO statement is an excellent tool to have in your arsenal if you’re a SQL developer. The SELECT…INTO statement: Creates a target table for you automatically, eliminating the need to manually create a table....
Jun 24, 2019 | Business Intelligence, SQL Server
By: Ken Adams Not Enough Space On my current engagement, we are trying to build a reporting platform that meets the needs of our client while simultaneously adhering to best practices. One of the best practices we’ve established as part of the platform is...
Jun 3, 2019 | Business Intelligence, Microsoft, SQL Server
By: Paul Schuliger Over a year ago I wrote an article that discussed using the SQL Window Function ROW_NUMBER() to set up a sort order within each layer of a hierarchy, and then showed how to use that information in Power BI. I recently found...
Mar 22, 2019 | Consulting, Microsoft, SQL Server, Tech Tips, Technical Information
By: Jason E. Bacani Introduction When working with SQL Server Agent, one of the many useful features is the ability to schedule SQL Agent Jobs. The frequency and scheduling of such jobs can be as fancy and as specific as needed, and can be coordinated with...
Mar 15, 2019 | Business Intelligence, Data Visualization, SQL Server, Tech Tips, Technical Information
By: Andy Kim Introduction If you ask a SQL professional to name some data types, you might hear: varchar, int, datetime, decimal, or something to that effect. Rarely do people mention the spatial data types of: geography and geometry. This is because most SQL...
