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,719 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
144 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,173 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,884 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
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 SQL PowerShell world in the last 15 months...
2017-06-07
11 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
17 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
499 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,643 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers