The Failed Job
I was looking into a failed job on a SQL Server 2008R2 instance. My first step was to check the...
2013-11-15 (first published: 2013-11-07)
1,672 reads
Create Semaphore in Sybase
It seems like I am going to write another none SQL stuff again. No. This is a real life scenario. I am writing an ETL for my customer to...
2013-11-07
12 reads
Create Semaphore in Sybase
It seems like I am going to write another none SQL stuff again. No. This is a real life scenario....
2013-11-07
1,226 reads
Recording of SQL Injection Webcast Now Available
On Tuesday I gave a webcast along with MSSQLTips on SQL Injection. If you were unable to attend (or were...
2013-11-07
364 reads
Free Online SQL Server Training for the Week of November 10, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-07
359 reads
Tabular model: Not ready for prime time?
While the tabular model in SSAS makes it much easier to build cubes than the multidimensional model, I am not...
2013-11-07
22,753 reads
My 5 pieces of advice for new DBAs
As my first post, I thought I’d list a few points that I would say to any new DBA. I’ll...
2013-11-07
808 reads
The Powershell Challenge
I’ve been wanting to do more with Powershell (PoSh). I’ve seen Allen White present on it for years, and I’ve...
2013-11-07
1,411 reads
Do your Foreign Keys Hate You?
We all love our databases. We trust everything they do! How could we not? It's our baby.... well, probably not....
2013-11-07
314 reads
Recording of SQL Injection Webcast Now Available
On Tuesday I gave a webcast along with MSSQLTips on SQL Injection. If you were unable to attend (or were...
2013-11-07
1,690 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers