One size does not fill all
Allowing your application to generate your SQL can be a really bad decision.
2014-03-06
184 reads
Jim Youmans
What is a Database Administrator today?
Today we have a guest editorial from Jim Youmans that asks "what does it mean to be a DBA today?"
2013-12-06
392 reads
2013-11-25 (first published: 2013-11-15)
2,052 reads
Restore Script Generator
Create restore script from a SQL Backup file. A must have for your DBA Tool Belt.
2013-06-18 (first published: 2013-05-30)
2,225 reads
Search all stored procedures on all databases
Need to find every stored procedure in any database that references the table FooBar? Here is a quick and easy search to do that.
2013-05-30 (first published: 2013-05-22)
1,634 reads
2013-04-30
667 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Error message in launching web service url in sql report server
I am getting the following error when I launch web service url in sql...
How to Pivot daily date to a week Row
I have data as below which is a per day view, I wish to...
SSRS Report Upgrade issue with # Temp tables for 800+ lines of Query
one of the Report which calls two Data sets , Data set1 Contains ,...
Ask SSC