Monday Morning SQL Break – May 23, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-05-23
405 reads
Monday Morning SQL Break – May 16, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-05-23
355 reads
PASS Board 2016: Update #3
I didn’t post an update last month, but I did do something more important: I elicited your feedback on a question...
2016-05-23
394 reads
Master_Views: master_objects, master_tables, etc
There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of...
2016-06-01 (first published: 2016-05-23)
1,587 reads
The Road to SQLSaturday Orlando – 2016
This year I’ll blog sporadically on the event, focusing on pain points, discoveries, and new ideas with the occasional progress...
2016-05-23
428 reads
How Do I Change My Domain Password on Windows Server 2012?
As a DBA I spend a lot of time in RDP sessions, both to SQL Servers and to "jump"/pass-through servers...
2016-05-23
5,972 reads
SQL Server Random Workload Generator
Hello Dear Reader! Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog). He’s an Microsoft Data Platform MVP, MCM, part of the...
2016-05-20
8 reads
SQL Server Random Workload Generator
Hello Dear Reader! Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog). He’s an...
2016-06-01 (first published: 2016-05-20)
2,201 reads
SQL Server Exercise for Data Warehouse Candidates
Background
Part of the process when looking for candidates to bring into a data warehouse team is to ensure that you hire...
2016-05-30 (first published: 2016-05-20)
2,586 reads
Simple Way to Decrypt SQL Server Stored Procedure
When stored procedures are created in SQL Server, their entire text body is accessible to all those who have the...
2016-05-20
51,464 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Getting Database MaiL Profiles
Comments posted to this topic are about the item Getting Database MaiL Profiles
Preserving Data
Comments posted to this topic are about the item Preserving Data
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers