Creating a configurable SSMS script
Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from ... Continue reading
2021-05-28 (first published: 2021-05-18)
781 reads
SQLStudies
#PowershellBasics: Comments and comment based help
I’ve talked about SQL Server comments before and how important they are. In PowerShell comments are important for all the same reasons and then some. So first of all...
2021-05-13
84 reads
What do you do when technology changes? : T-SQL Tuesday #138
Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us to discuss how we handle changes ... Continue reading
2021-05-11
19 reads
All jobs that ran during a given time frame.
Short post today. Simple query that will tell you every job that ran between two datetime stamps. Note: this of ... Continue reading
2021-05-17 (first published: 2021-05-06)
678 reads
SQL Homework – May 2021 – Extended Events.
You’ve probably heard about extended events right? I honestly don’t care if you are #teamProfiler or #teamXE you need to ... Continue reading
2021-05-04
129 reads
WITDC Mental Health and Wellness Day- May 7th
Next Friday WITDC is having a Mental Health and Wellness Day virtual event and I’ll be speaking! I can’t tell ... Continue reading
2021-04-29
32 reads
#PowershellBasics: Setting a variable vs a comparison.
In SQL Server both the set and equality functions are handled by the equals sign (=). For example: Set Equality ... Continue reading
2021-05-10 (first published: 2021-04-27)
411 reads
Right sizing int : T-SQL Tuesday #136
Brent Ozar (blog|twitter) is our host this month, which will make this the most popular #tsql2sday to date I’m sure. ... Continue reading
2021-03-15 (first published: 2021-03-09)
327 reads
What is the CONTROL permission?
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: ... Continue reading
2021-01-27 (first published: 2021-01-19)
548 reads
“They need help, we must help.” #forGarethSwan
We just finished a memorial for Gareth Swanepoel. He was an amazing person and someone I wish I’d gotten to ... Continue reading
2021-01-22 (first published: 2021-01-14)
329 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor Resmi BCA KCP Gorontalo Tlp:08218154393
WA:08218154393 Jl. Nani Wartabone No.293, Limba U I, Kota Sel., Kota Gorontalo, Gorontalo 96111
Alamat Kantor Resmi BCA KCP Ratulangi Tlp:08218154393
WA:08218154393 Jl. Dr. Sam Ratulangi No. 7, Kompleks Ratulangi Office Park Blok A3-A4, Kota...
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers