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,711 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
142 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,140 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,883 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
370 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
15 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
8 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
498 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
6 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,629 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers