Configure an Azure AD Domain Services
Problem: I was working on getting a demo on how to setup Always On with SQL Server 2017 without the...
2017-11-20
168 reads
SQL Operation Studio Tool
Microsoft finally has launched most awaited tool – SQL Operation Studio (aka OpsStudio)!!!
SQL Operation studio is a lightweight open source...
2017-11-20
1,571 reads
File This Under File Groups (Part 1)
I never had cause to give much consideration to storage when I was a SQL developer. The companies I worked...
2017-11-19
451 reads
Lost in Big Data, perhaps Small Data could help
(2017-Nov-19) I don't remember how I actually found this book "Small Data: The Tiny Clues that Uncover Huge Trends". Most...
2017-11-19
1,298 reads
How to Calculate Running Totals in SQL Server
In show #84 of the SQL Server Radio Hebrew Edition, Matan and I talked about how to calculate running totals in SQL...
2017-12-01 (first published: 2017-11-19)
2,894 reads
Customer Satisfaction Survey Results
In the last couple of months, we sent our first customer satisfaction survey to all our customers. We collected the...
2017-11-18
519 reads
What is the Role of the UPDATE Lock in SQL Server?
The most common types of locks in SQL Server are the SHARED (S) lock and the EXCLUSIVE (X) lock. The...
2017-11-18
1,412 reads
One Line of Code Is All It Takes
This tweet showed up in the dbatools Slack channel Friday afternoon.
Just did my first Pull Request to "contribute" to @psdbatools. Granted, the code change was a single line of...
2017-11-18
9 reads
One More Trip and Down for the Count
The last month has been a rough one for me, with lots of travel. I was on trips for 4...
2017-11-17
1,010 reads
New Session: Data Types Do Matter
I started speaking on a semi-regular basis this year after many years of trepidation. You can read about my first...
2017-11-17
311 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