Culture Shock
The work I’m doing right now has nothing to do with SQL Server, and while it deals with technology, it’s...
2011-11-14
696 reads
Blog Posts
DBA in Space: Behind the Scenes Part 1
The DBA in Space contest ends November 18, 2011. If you haven’t entered yet, you still have time.
Filming DBA in...
2011-11-14
730 reads
DBCC CHECKDB
Torn Pages \ Corrupt pages – all in a days work for a DBA. But can anyone tell me how to use...
2011-11-14
29,111 reads
Do You Use “Forced Parameterization”?
In SQL Server 2005 and later, there is a database option called “forced parameterization”. When it is turned on, it...
2011-11-14
797 reads
Lists of Words You May Not Know
The Merriam-Webster site has an interesting list of Top 10 Lists, ranging from commonly confused words to things you didn’t...
2011-11-14
647 reads
Many-to-Many Dimensions
In SSAS, data structures do not always conform to the snowflake or star schema model where one fact is associated...
2011-11-14
1,515 reads
No SQL Saturday - Columbia, SC in 2012
Last week my partner in crime, Bobby Dimmick (blog | twitter) and I sat down for lunch and caught up and...
2011-11-14
1,672 reads
Some SQL Server Security Housekeeping
Managing SQL Server security changes in mass is something which screams automate it. Let’s look a at few examples using...
2011-11-14
1,666 reads
SQL Inspire NYC – 2011
The lineup for SQLInspire
I spoke at the SQL Inspire event this last weekend and it was a greart experience. This...
2011-11-14
1,504 reads
SQL Server – Error Msg 102, Level 15, State 1, Line x when using sys.dm_db_index_physical_stats
You run into this error when using sys.dm_db_index_physical_stats DMV on a database which is running under SQL Server 2000 (80)...
2011-11-14
1,868 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