Do you know Compress & Decompress function in SQL SERVER 2016 ?
This is another article in the series of SQL SERVER 2016 Journey . I am pretty much sure you might aware...
2016-10-16
1,531 reads
Blog Posts
Here Come New Ideas for DROP IF EXISTS in SQL SERVER
In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a...
2016-10-15
1,146 reads
An observation about Unicode in SQL Server Management Studio
A week or so ago I read a blog post and tweet about using an emoji in SQL Server. This...
2016-10-14 (first published: 2016-10-02)
2,261 reads
Control Flow Package Parts in SSIS 2016
Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server Integration Services packages. The intent is great, but like...
2016-10-14
180 reads
Mastering Index – Unique Index
This article is the part of series Mastering Index, in this particular article we will be exploring Unique Index. Take a...
2016-10-14
472 reads
Searching SQL Servers & Saving Results, with Write-SqlTableData
Just a quick blog today to show you something which is possible with a handful of lines of code. I...
2016-10-14
284 reads
Searching SQL Servers & Saving Results, with Write-SqlTableData
The other day I was chatting with my friend Tom Roush ( B | T ) and he mentioned needing to scan every database on every SQL Server instance...
2016-10-14
71 reads
Special Discount for PASS Summit Precon
I’m very honored to be speaking at the PASS Global Summitagain this year in Seattle during the week of October...
2016-10-14 (first published: 2016-10-10)
758 reads
What’s new in SSRS 2016 – Session Contents
The 2016 edition of the Belgian SQL Server Days is over. It was a blast – as usual – and it was...
2016-10-14
530 reads
A quick note comparing ISNULL vs COALESCE
There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...
2016-10-13
1,303 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