Becoming a DBA, Part I
A recent thread on SQLServerCentral.com had an individual what it took to be a successful DBA. Couple that with a...
2007-10-29
1,680 reads
Structuring the Blog Better
For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like....
2007-10-28
1,468 reads
Views for Abstraction Posted on SSC
This went up today and there is one great comment about possibly using snapshot isolation as an alternative to the...
2007-10-25
1,365 reads
Steve Jones Finally Reads My Blog!
I've been following Steve's exploits trying to learn the podcasting business and we usually talk about it once a week...
2007-10-25
1,463 reads
SQLSaturday Finally Listed in PASS Connector
If you subscribe to the Connector (the main communication email from PASS.org) you should have gotten one yesterday that finally...
2007-10-25
1,400 reads
Alpha Version of SQLPing3 Command Line Available
Noted SQL Server security expert, Chip Andrews, has released an alpha version of a command-line version of SQLPing3. You can...
2007-10-25
2,313 reads
Untitled Pages in ASPX
If you do any coding in .Net using aspx pages you'll recognize this one. Each page has a title attribute...
2007-10-24
1,483 reads
Be Pithy
I'm tech editing a book, working late as usual, football game on and kids in bed. As I was going...
2007-10-22
1,395 reads
Requiring Columns Over 900 Bytes to Be Unique
Had a friend call me recently to ask about how to do this, had an nvarchar(2000) column that needed to...
2007-10-22
1,457 reads
If Exists (Select 1...) vs If Exists (select * ...)
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-21
1,841 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