Basics of Probability
In this post am going to introduce into some of the basic principles of probability – and use it in other posts...
2017-03-30 (first published: 2017-03-20)
4,514 reads
Testing Your SQL Server Backups the Easy Way with PowerShell & dbatools
In a previous post I wrote about how easy it was to restore a whole SQL Servers user databases from...
2017-03-20
1,012 reads
TDE: Looking inside your database and backups
TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file...
2017-03-20
321 reads
Restoring an entire SQL Server user databases with PowerShell using dbatools
All the good DBAs backup their databases.
A significant amount of SQL DBAs use Ola Hallengrens maintenance solution to do so.
This...
2017-03-29 (first published: 2017-03-18)
3,058 reads
An Introduction to SQL Server 2016 Query Store
By David Postlethwaite
David is delivering a talk An Introduction to SQL Server Query Store at SQL Saturday Iceland today - this...
2017-03-18
728 reads
SQL Bits in less than a month
I’m getting excited, and you should as well. Join me at a fantastic conference in the UK this spring. Register...
2017-03-17
507 reads
Schedulers To Rule Them All
Sometimes things just don’t make sense.
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled. This...
2017-03-17
871 reads
SQL Server: DBCC CHECKDB Command with Complete Explanation
SQL Server is used widely for the management of database. It is possible that the data gets corrupt due to...
2017-03-17
2,532 reads
When NOLOCK LOCKS!
This is hardly breaking news, but it’s important to know: when using NOLOCK table hints in SQL Server, it can...
2017-03-17
3,124 reads
PASS Excel BI VC: Improvements to Excel Pivot Table
Please join the PASS Excel Business Intelligence Virtual Group onn March 22nd 11AM Eastern for Microsoft’s Program manager Alexander Lahuerta....
2017-03-17
512 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