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,764 reads
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,764 reads
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,590 reads
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,114 reads
Next week I will be in Seattle for the 2014 SQL Pass Summit event. If you are involved in projects...
2014-10-30
1,153 reads
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,363 reads
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,316 reads
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,008 reads
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
982 reads
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,191 reads
Introduction of how to design a star schema dimensional model for new BI developers
2014-09-09
8,374 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers