Disabling the identity cache in SQL Server 2017
One of the changes that’s been brought into the database engine in SQL Server 2017 is the ability to disable...
2017-06-07 (first published: 2017-05-24)
4,731 reads
Blog Posts
How to write an UPDATE query
My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This...
2017-06-07
149 reads
Identifying failed queries with extended events
Back to some core SQL this week and one of my favourite features, extended events.
Introduced in SQL Server 2008...
2017-06-07
6,197 reads
Import Export Wizard Mapping Files
Recently I had to copy data from our AS400 to a SQL Server database. Normally I would whip up my...
2017-06-07
3,889 reads
Random Advance C# FAQs
Difference between const, readlonly and static readonly? const: const variable value is set as constant value at compile time. it can not...
2017-06-07
371 reads
SQL PowerShell Pre Con at SQL Saturday Chattanooga
I happy to be doing a PreCon at SQL Saturday Chattanooga on Friday June 23rd. A lot has changed in the SQL PowerShell world in the last 15 months...
2017-06-07
9 reads
SQL PowerShell Pre Con at SQL Saturday Chattanooga
I happy to be doing a PreCon at SQL Saturday Chattanooga on Friday June 23rd. A lot has changed in the SQL PowerShell world in the last 15 months...
2017-06-07
19 reads
SQL PowerShell Pre Con at SQL Saturday Chattanooga
I happy to be doing a PreCon at SQL Saturday Chattanooga on Friday June 23rd. A lot has changed in the SQL PowerShell world in the last 15 months...
2017-06-07
13 reads
SQL PowerShell Pre Con at SQL Saturday Chattanooga
I happy to be doing a PreCon at SQL Saturday Chattanooga on Friday June 23rd.
A lot has changed in the...
2017-06-07
500 reads
SQL Puzzle 1: Magic Squares
This is the first in what I hope will be a semi-regular series of recreational puzzles where SQL can be...
2017-06-07
1,658 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers