Azure SQL Server Database
SQL Server in Azure
You can create and leverage cloud based SQL Server instances using Microsoft Azure. However, if you have...
2014-12-04 (first published: 2014-12-01)
6,773 reads
Business Intelligence and Enterprise Architecture
SQL Server Management Studio Reports
SQL Server Management Studio Reports
Whether you are an Application, SQL, BI Developer or a DBA. Knowing what is occurring within...
2014-11-21 (first published: 2014-11-17)
7,605 reads
SQL Server Table Partition Example
Why Use a SQL Server Table Partition
Data warehouses and data repositories often have tables that store millions of records and...
2014-11-03
5,167 reads
SQL Pass Summit 2014
Next week I will be in Seattle for the 2014 SQL Pass Summit event. If you are involved in projects...
2014-10-30
1,163 reads
SQL Server TABLESAMPLE
Using TABLESAMPLE in SQL Server
SQL Server has several ways for you to limit the number of records returned from a...
2014-10-28 (first published: 2014-10-20)
7,450 reads
SQL Server Checksum
Use SQL Server Checksum in Data Warehousing
When building data warehouses you often need a fast way to know if the...
2014-10-14
2,363 reads
Common Table Expressions (CTE)
Common Table Expresseion (CTE)
A common table expression (CTE) is a derived table that is defined and only stored for the...
2014-10-08 (first published: 2014-10-03)
9,016 reads
SQL Server 2014 Cardinality Estimator
SQL Server 2014 Cardinality Estimator
The SQL Server 2014 cardinality estimator has been improved to increase the quality of SQL Server query...
2014-09-25
994 reads
Schema on Read vs Schema on Write
Schema on Read vs Schema on Write in Business Intelligence
When starting build out a new BI strategy. There are more...
2014-09-12
1,206 reads
Business Intelligence Strategy – Beginning Steps
Business Intelligence Strategy
A business intelligence strategy is used to determine where an organization is and where they are going with...
2014-09-01
739 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers