As a DBA, we are often tasked with maintenance work on the database. Often this includes making sure that old data is purged from the tables. This is especially true with logging tables. Sometimes multiple applications write to the same logging tables, and they can grow very quickly. Let’s say we have a logging table […]
2021-10-15
12,295 reads
2021-10-08
1,931 reads
2017-04-12
6,133 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
3,669 reads
2017-02-28
10,288 reads
Allowing your application to generate your SQL can be a really bad decision.
2014-03-06
184 reads
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
I am getting the following error when I launch web service url in sql...
I have data as below which is a per day view, I wish to...
one of the Report which calls two Data sets , Data set1 Contains ,...
Ask SSC