My First PASS Experiences
Getting to Seattle
I started my travels to the PASS Summit at about 9:30 am (EST) on Sunday and arrived at...
2009-11-03
714 reads
Importing a SQL Server 2008 Analysis Services Database
Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to...
2009-11-03
1,053 reads
Date Expressions in SSIS
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-11-03
594 reads
Quickly View Session Information with Query Text
One of the most common problems facing a DBA or developer in troubleshooting performance is identifying what processes, and by...
2009-11-03
440 reads
South Florida SQLSaturday
It’s very exciting to be involved with the SQL Saturday here in South Florida. There are already so many great...
2009-11-03
342 reads
Ups and Downs of Cases in SSMS 2008
Recently I was working with client and they were discussing the pet peeves of some of the new intellisense features...
2009-11-03
402 reads
Tabs Out of Control
I was working with a team of developers this week who were having the hardest time finding the keystroke to...
2009-11-03
332 reads
Table and Index Partitioning Demo
I get a lot of requests for explanations about the different concepts and the easiest way to demo partitioning in...
2009-11-03
359 reads
Smooth Compound Operators
Ok, so I can’t promise you’ll be smooth by the end of this entry, but I can promise you’ll be...
2009-11-03
244 reads
Kick xp_sendmail to the curb
With the advent of SQL Server 2005 and 2008, mail in the database engine has changed dramatically. Previously you had...
2009-11-03
1,435 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