Creating a SQL 2016 CTP2 Virtual Machine in Azure
With the CTP2 of SQL Server 2016 now released you may be eager to try it out. One of the...
2015-05-28
2,485 reads
SQL Server 2016 Live Query Statistics
So now that SQL Server 2016 CTP2 is released to the public we can all finally play with all the...
2015-05-28
3,151 reads
Multiple Windows Groups with different default databases
A question came up at work the other day, mostly as a mind game, but you never know it might...
2015-06-08 (first published: 2015-05-28)
1,859 reads
Microsoft Azure SQL Databases – Power and Performance
By David Postlethwaite
On the Database Scale page we can decide on the performance level that we want our database to...
2015-05-28
1,038 reads
SQL 2016 Preview has been released!
For those who haven’t noticed already:
SQL Server 2016 CTP2 (or Preview as some call it) has just been released!
This means...
2015-06-01 (first published: 2015-05-28)
3,286 reads
Sysmail_add_account_sp – SQL Server Database Mail Stored Procedure – Part 5
Hi friends, today we will continue with database mail stored procedure and will learn how to create database mail account...
2015-05-28
975 reads
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
MAY 28, 2015
For those of you who have been following along with this series of posts,...
2015-05-28
117 reads
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the ShardsMAY 28, 2015
For those of you who have...
2015-06-05 (first published: 2015-05-28)
4,138 reads
Integrating Other Data Mining Tools with SQL Server, Part 1.1: The Weaknesses of WEKA
By Steve Bolton
…………The same rules that applied to my amateur mistutorial series on A Rickety Stairway to SQL Server Data...
2015-05-28
2,369 reads
Visualizing the Tally Table
I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem...
2015-05-27
910 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers