The CONNECT permission
The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at...
2016-02-03 (first published: 2016-01-27)
3,413 reads
Blog Posts
The Future of SSMS
One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a...
2016-02-03
630 reads
Advent of Code – Day 2 – Using Cross apply
For this post i worked on second puzzle in the Adventofcode series. This wasn’t as challenging as the first one, but...
2016-02-02
316 reads
Azure SQL DB – technical deployment
Take a look this awesome document for the Azure SQL DB technical deployment with lot of the details that you need...
2016-02-02
520 reads
Goodness-of-Fit Testing with SQL Server Part 4.2: The Hosmer–Lemeshow Test with Logistic Regression
By Steve Bolton
…………The last installment of this amateur series of self-tutorials was the beginning of a short detour into using...
2016-02-02 (first published: 2016-01-26)
1,539 reads
Pausing PASSWatch & What’s Next
I just posted Pausing PASSWatch on the PASSWatch blog, wrapping up a project that ran about 16 months. It’s hard...
2016-02-02
614 reads
Should I use option(recompile)?
Should I use option(recompile)?
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of...
2016-02-02
6,959 reads
Should I use option(recompile)?
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of the content located...
2016-02-02
2,118 reads
Speaking at OPASS on February 25, 2016
Last month I visited MagicPASS, this month I’ll be at oPASS and presenting again on my pattern for automating database...
2016-02-02
557 reads
SSC Question of the Day: DBCC Error 6
My latest question of the day on SQLServerCentral is DBCC Error 6. Text of the question below:
As the on-call DBA,...
2016-02-02
2,062 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers