Last week reading (2018-10-21)
DevOps Terms – and Why They Matter to Database Specialists Find out what is Scrum, Continuous Deployment, TDD and others from...
2018-10-21
74 reads
SQL Server 2019
I have written about 2017 here, Last month at Microsoft Ignite FL on September 2018, Microsoft announce they are going to...
2018-10-20
278 reads
Notes from SQLSaturday #801 (2018)
We wrapped up our 12th SQLSaturday here in Orlando two weeks ago. Overall things went well. Registration was just a...
2018-10-20
260 reads
Installing Azure Data Studio
Azure Data Studio is the newest tool from Microsoft for working on the data platform. Last year we saw the...
2018-10-31 (first published: 2018-10-19)
4,510 reads
SQL Server – Reading BACPAC Files
If you have been reading my blog for a while now you would know that a common technique to move...
2018-10-19
278 reads
Contextual View Part II or how to hide sensitive data
In this article I continue to explore the ways to secure the data via contextual views and describe the technique...
2018-10-18
547 reads
Step-by-Step: How to Trigger an Email Alert from Windows Performance Monitor
Windows Performance Counter Alerts can be configured to be triggered on any Performance Monitor (Perfmon) Counter through the use of...
2018-10-18
1,641 reads
Pagination pattern or how to fetch a large dataset for a web report.
In this post we will discuss how to fetch data from a large dataset for web applications using pagination technique....
2018-10-17
420 reads
Fix SQL Server with one click
Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration...
2018-10-17
299 reads
Invalid value given for parameter PASSWORD. Specify a valid parameter value.
I still use sp_help_revlogin to transfer logins between servers. I know there are other options, including a set of Powershell...
2018-10-30 (first published: 2018-10-17)
7,773 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
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...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
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...
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