Remote DBA
I'm getting ready to look for a new cell phone and I got lots of suggestions from my editorial on...
2006-01-05
1,529 reads
Simple Script to Report Tables Sizes in a SQL2K Database
Last week we had an issue with a database growing unexpectedly. The
database in question supported an infrastructure type 3rd party
application...
2006-01-04
1,349 reads
Sample Chapter from Professional SQL Server 2005 Integration Services
Brian Knight posted a sample chapter for Professional SQL Server 2005 Integration Services
to his blog a few days ago. Last...
2006-01-04
1,481 reads
Philosophy on Soldiering
This is taken from the book About Face:The Odyssey of an American Warrior.
The author is Col. David "Hack" Hackworth, one...
2006-01-01
1,422 reads
The Perils of Java Schools
This is great, another rant from Joel, this time on the state of CS Degrees.
I didn't grow up in the...
2005-12-30
1,608 reads
Last Minute Testing
I've had a new web server for a couple months and I've been slowly testing things as I can in...
2005-12-28
1,375 reads
Unpatched Microsoft Windows WMF Vulnerability
If you haven't heard by now, there is an unpatched exploit in how
Windows handles WMF files. Since this handling is...
2005-12-28
1,438 reads
Cute comic
My son ran across this comic and was sure I would enjoy it: http://www.qwantz.com/index.pl?comic=153
2005-12-23
1,573 reads
SQL Server Connections
I found out today that I will get to attend the SQL Server Magazine Connections conference (part of the DevConnections...
2005-12-21
1,407 reads
Aggregate queries
Be sure to read my article on SQLServerCentral on building aggregate queries: http://www.sqlservercentral.com/columnists/kKellenberger/aggregatequeries.asp
2005-12-21
1,596 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
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