Normalization, The Sequel
If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system...
2017-04-05
118 reads
[Video] JSON Usage and Performance in SQL Server 2016
Last night I had the privilege to present to the Ohio North SQL Server User Group about JSON in SQL Server 2016. There was a great crowd present (they...
2017-04-05
8 reads
Is There A Threat Inside?
If you’ve been involved in technology for any length of time you are aware of outside threats to your network...
2017-04-05
374 reads
What’s Next for SQL Clone?
I think SQL Clone is a useful, handy product. It’s what I’ve needed in a number of organizations, or it’s...
2017-04-05
650 reads
How do I change the increment of an identity column?
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. No...
2017-04-05
494 reads
Columnstore Indexes – part 103 (“Partitioning 2016 vs Partitioning 2014”)
Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have been wanting to write on...
2017-04-05
437 reads
Connecting a powershell session to a container
One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within...
2017-04-05
173 reads
Connecting a powershell session to a container
One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within...
2017-04-05
471 reads
Getting SQLServers Last Known Good DBCC Checkdb with PowerShell and dbatools
As good SQL Server DBA’s we want to ensure that our databases are regularly checked for consistency by running DBCC...
2017-04-05
653 reads
ADO Connection Resiliency
It’s not easy to keep up with tech, here’s an update I missed – you can add params to the connection...
2017-04-05
670 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