SQL Server 2017 Reporting Services: The Basics Part 2
Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time...
2019-02-22 (first published: 2019-02-01)
3,074 reads
Financial Advice for Techies
I’m not writing a post here on how to manage your money, but I will point you to Troy Hunt’s...
2019-02-22 (first published: 2019-02-01)
2,906 reads
How many plans are in the plan cache for a stored procedure?
It depends on where you’re looking and how many statements are in the stored procedure.
Let’s take a look at some...
2019-01-31
563 reads
How Does DBCC CHECKIDENT Really Work When Resetting the Identity Seed (RESEED)?
(last updated: 2019-01-31 @ 22:45 EST / 2019-02-01 @ 03:45 UTC )
Today’s “Question of the Day” on SQL Server Central, Cleaning up the...
2019-02-20 (first published: 2019-01-31)
6,330 reads
Azure Notebooks – a nice little tool.
Gday,
I’ve been playing with Azure notebooks lately and have found them invaluable as
A teaching aidA test sandboxI’ve been using Python...
2019-01-31
1,105 reads
How To Check How Far Behind Your SQL Server Log Shipping Secondary Is
Log shipping is one of the simplest and most bulletproof methods to get SQL Server to replicate data to a...
2019-02-21 (first published: 2019-01-31)
2,767 reads
Index maintenance freebies
I didn’t expect anything for free in index maintenance. After all, it takes a lot of CPU and transaction log...
2019-02-20 (first published: 2019-01-30)
2,435 reads
Understanding and working with NULL in SQL Server
Graphic representation of the difference between 0 and NULLImage taken from 9gag.com
According to database theory, a good RDBMS must implement a marker to indicate "Missing or inapplicable information".SQL Server...
2019-01-30
14 reads
Webinar next week on Database DevOps
Next week is my webinar on why the database is the heart of DevOps. You can still register today to...
2019-01-30
754 reads
Understanding and working with NULL in SQL Server
Graphic representation of the difference between 0 and NULL
Image taken from 9gag.comAccording to database theory, a good RDBMS must implement...
2019-01-30
1,446 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