SQL Server 2016 SP1 Release - Thoughts and Comments!!!
SQL Server 2016 SP1 has released last night and most of the features that were previously part of enterprise edition...
2016-11-17
725 reads
Blog Posts
Why would you never use SSIS Fast Load…?
We all know that if you want SQL Server to push data into a table then you want to batch the...
2016-11-17 (first published: 2016-11-14)
9,504 reads
DLM Automation–Making a Database Connection
One of the things I’ve been wanting to do is dig more into the command line automation cmdlets from the...
2016-11-16
680 reads
Enabling Cortana for dbareports PowerBi
Last week at the Birmingham user group I gave a presentation about PowerShell and SQL Server
It was a very packed...
2016-11-16 (first published: 2016-11-13)
1,833 reads
Parallel Powershell for Running SQL
This is just a quick look. I plan on diving into this in the future more, as I'm still working...
2016-11-16
3,383 reads
Parallel Powershell for Running SQL
This is just a quick look. I plan on diving into this in the future more, as I'm still working...
2016-11-16
233 reads
Persisting DBCC output data
Most of the DBCC commands return their results as textual output, even if you have SSMS configured to return result...
2016-11-16
462 reads
SQL Server & Containers – Part One
Containers are a hot topic at the moment, there seems to be a new article about them on Hacker News...
2016-11-16
654 reads
SQL Server 2016 Service Pack 1 – What’s New
With the release of the most epic Service Pack 1 for SQL Server 2016, the biggest attention of everyone should...
2016-11-16
841 reads
SQL Server 2016 Service Pack 1 Changes Everything
Earlier today, Microsoft announced the release of Service Pack 1 (SP1) for SQL Server 2016. Pay close attention to this...
2016-11-16
481 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