Virtualization for SQL Server DBAs – New SQL Saturday Pre-Con Session
Today I am officially announcing the launch of my first all-day SQL Saturday Pre-Conference training session entitled “Virtualization for SQL...
2013-10-30
1,220 reads
First take on PowerPivot
What is PowerPivot for Excel? PowerPivot brings the power of Data Modelling into your PC. Traditionally, the DataWarehouse is built...
2013-10-30
1,667 reads
Is There Interest in SQL Server Security Pre-Cons?
I’m very passionate about security, especially database security. As the numbers with regards to data breaches continue to climb, this...
2013-11-05 (first published: 2013-10-30)
2,730 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.5: The Predict Method
By Steve Bolton
…………In order to divide the Herculean task of describing custom algorithms into bite-sized chunks, I omitted discussion of...
2013-11-04 (first published: 2013-10-30)
2,791 reads
sp_BackupDatabases v1.2
I just posted a new version of sp_BackupDatabases. The biggest change is that the procedure now creates one-time SQL Agent...
2013-10-29
1,625 reads
Fixing Cardinality Estimation Errors with Filtered Statistics
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Cardinality Estimation is...
2013-11-01 (first published: 2013-10-29)
3,527 reads
PASS Summit 2013
Not much news came out of the PASS Summit 2013 from last week, but boy did I have a blast! I...
2013-10-29
1,131 reads
Query Tuning in Dallas
Let’s have some fun.
This Friday, November 1, 2013, I’m putting on an all day seminar on query tuning. It’s set...
2013-10-29
678 reads
Startup Weekend Orlando
Startup Weekend comes to Orlando on Nov 22-24, 2013. I haven’t been (and not sure I will make this one)...
2013-10-29
756 reads
The times they are a-changin’
This blog post will not be about Bob Dylan, but rather about some professional changes/challenges I’ve been up to lately.
The...
2013-10-29
500 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