A Mess of Nested Transactions
Transactions are an area that I often find are used badly, or not used at all. Transactions without any error...
2015-11-03
848 reads
Blog Posts
Columnstore Indexes – part 72 (“InMemory Operational Analytics”)
Continuation from the previous 71 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have previously written on the Rowstore...
2015-11-03
552 reads
Configuring the Azure SQL Database Firewall
Azure SQL Database is a Platform as a Service (PaaS) that provides a relational database for use over the internet....
2015-11-03
599 reads
DLM Dashboard moves to 50 Databases – For FREE
I love DLM Dashboard. It’s the product that I’ve written myself, in various ways since SQL Server 6.5. My versions...
2015-11-03
742 reads
Git Push in SQL Source Control
I’m excited. Git support is growing in SQL Source Control and the release recently contains Git push/pull support. If you...
2015-11-03 (first published: 2015-10-22)
2,302 reads
Goodness-of-Fit Testing with SQL Server, part 2.1: Implementing Probability Plots in Reporting Services
By Steve Bolton
…………In the first installment of this series of amateur self-tutorials, I explained how to implement the most basic...
2015-11-03
1,297 reads
Histograms and Events
The last few articles covered the pair_matching target and some uses and details that go along with it. For a...
2015-11-03 (first published: 2015-10-22)
1,883 reads
Looking Back at Summit 2015
Last week was the 2015 PASS Summit in Seattle. It’s the largest SQL Server specific gathering of data professionals in...
2015-11-03
675 reads
PASS Summit 2015 Recap
Last week was the annual PASS Summit in Seattle. The Summit is the predominant educational and networking event for SQL...
2015-11-03
617 reads
ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can...
2015-11-03
28 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