Increasing and decreasing the performance level of your Azure SQL Database
One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability...
2017-03-29
730 reads
What Is A Day?
When designing a data warehouse or reporting architecture, the smallest questions can pose some of the biggest challenges. Identifying what...
2017-03-29
613 reads
SSMS – Not a Valid Value for Property Width
I’ve had this happen a couple of times with a recent build of SSMS. Something went wrong – resolution change maybe...
2017-03-29
1,255 reads
Getting SQL Server File Sizes and Space Used with dbatools
I read a great blog post about answering the question how big is the database using T-SQL on SQL Buffet...
2017-03-29
986 reads
Using SQL Client Aliases
SQLServerCentral.com recently published my case study on how my company implemented Windows Containers running SQL Server to streamline our QA...
2017-03-29
177 reads
Using SQL Client Aliases
SQLServerCentral.com recently published my case study on how my company implemented Windows Containers running SQL Server to streamline our QA...
2017-03-29
1,643 reads
Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Orange County)
on Apr 1st 1.30 pm, I will be presenting “consolidated essential performance health check using powershell” @ sqlsaturday, Orange County, if...
2017-03-29
451 reads
SQL Server Database Recovery Process Internals – database STARTUP Command
A database recovery process is an essential requirement for database systems, It can be a tedious job and the process...
2017-03-28
604 reads
Who Stuck These Letters In My DateTimes?
Parsing, creating, and modifying JSON in SQL Server 2016 is really easy. JSON dates and times are not.
Coming from a predominantly SQL background, the JSON DateTime format took some...
2017-03-28
34 reads
SQLSaturday Madison – April 7-8
The first event I ever spoke at was SQLSaturday in Madison, Wisconsin, back in 2012. I was petrified – would anyone...
2017-03-28
387 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