Creative XE Sessions – Funky Data
Playing around with emojis in a database is a fun endeavor. Not only is it fun to play with for personal growth, but it does have some business advantages.
Related...
2020-01-04
105 reads
Blog Posts
Creative XE Sessions – Funky Data
Playing around with emojis in a database is a fun endeavor. Not only is it fun to play with for personal growth, but it does have some business advantages.
Related...
2020-01-04
15 reads
Creative XE Sessions – Funky Data
Playing around with emojis in a database is a fun endeavor. Not only is it fun to play with for personal growth, but it does have some business advantages.
Related...
2020-01-04
1 reads
Checking SSIS Variable Values During Runtime
As anyone who reads my blog on a regular basis knows, I’m a big fan of using dynamic configurations, including SSIS parameters variables, to make my ETL architectures as...
2020-01-03 (first published: 2019-12-21)
1,062 reads
Creative Extended Event Sessions
A picture is worth a thousand words, right? Sometimes, a picture for an event session just may be able to say it better than 50-60 letters used to try...
2020-01-03
246 reads
Creative Extended Event Sessions
A picture is worth a thousand words, right? Sometimes, a picture for an event session just may be able to say it better than 50-60 letters used to try...
2020-01-03
Happy New Year!
Happy New Year!! Yes, I know it was two days ago but I’m still pseudo-on-vacation-not-really so just another simple blog post wishing you prosperity, health, and good tidings this...
2020-01-03
5 reads
SQLSaturday Orlando Notes – The Five Hats
I want to wrap up the notes on SQLSaturday by writing about my approach to managing events that I’ve evolved at SQLSaturday but definitely applies to most events and...
2020-01-03 (first published: 2019-12-16)
256 reads
T-SQL Basics: using OUTPUT
You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...
2020-01-03
11 reads
Upcoming Speaking Engagements
I presented a few times in 2019, and I’m starting off 2020 with several as well. Here’s what’s on the schedule for Q1.
2020-01-06 Yep, ISO8601 format. That’s how I...
2020-01-03
3 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
Forums
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers