Extract CLR Assemblies from SQL Server
I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to...
2012-03-02
3,228 reads
Extract CLR Assemblies from SQL Server
I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to do a comparison between two versions to make sure...
2012-03-02
432 reads
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor...
2012-02-17
1,421 reads
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor and store those readings in a csv file for...
2012-02-17
54 reads
Automate CPU-Z Capture to Check for Throttled Processors
Severalprofessionalshaveposted about checking whether or not your processors are running at full speed by using CPU-Z. Some recommendations are to...
2012-02-16
1,144 reads
Automate CPU-Z Capture to Check for Throttled Processors
Several professionals have posted about checking whether or not your processors are running at full speed by using CPU-Z. Some recommendations are to check your servers every couple of...
2012-02-16
52 reads
Script level upgrade for database ‘master’ failed
A few weeks ago one of our clustered server nodes blue-screened and when it came back on SQL refused to...
2011-11-09
4,505 reads
Script level upgrade for database ‘master’ failed
A few weeks ago one of our clustered server nodes blue-screened and when it came back on SQL refused to start. I started digging in and this is what...
2011-11-09
1,107 reads
Script level upgrade for database ‘master’ failed
A few weeks ago one of our clustered server nodes blue-screened and when it came back on SQL refused to start. I started digging in and this is what...
2011-11-09
17 reads
Sync SSMS Tools Pack Across Computers Using SyncToy
My favorite and most used feature of the SSMS Tools Pack is the query history. This feature has saved me...
2011-10-06
1,147 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
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...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers