This Week In Data – Episode 9 (What Does Pizza Have to Do with the Cloud?)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-10-19
736 reads
Blog Posts
Webinar Available On Demand – Building an Auditing Framework for SQL Server
Recently I gave an introductory webinar on how to build an auditing framework for SQL Server. The focus was for...
2016-10-19
508 reads
Azure SQL Database DMVs
The following DMVs shown within this blog post are some of the more common ones that I am finding really...
2016-10-18
485 reads
Columnstore Indexes in 2 minutes
The standard way of storing relational database tables on physical media is row based, that is, each row occupies a...
2016-10-18
216 reads
Columnstore Indexes in 2 minutes
The standard way of storing relational database tables on physical media is row based, that is, each row occupies a contiguous space. The term that is used for this...
2016-10-18
12 reads
Easy SQL Maintenance with Minionware
Here's my personal tweaked settings for deploying Minionware's fantastic Reindex & Backup jobs. In the development environment, I wanted to have...
2016-10-18
229 reads
Easy SQL Maintenance with Minionware
Here's my personal tweaked settings for deploying Minionware's fantastic Reindex & Backup jobs. In the development environment, I wanted to have...
2016-10-18
589 reads
2016-10-18
493 reads
Mastering Index – Index with included columns
This article is the part of series Mastering Index, in this particular article we will be exploring Index with included...
2016-10-18
495 reads
October 2016 SQL Mastery Sessions
Everyone is really excited about PASS Summit being right around the corner and as usually happens, the folks at the...
2016-10-18
396 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers