How wait statistics are generated
How wait statistics are generated
In our last article “Why wait statistics are important and how you can start collecting them...
2014-03-06
701 reads
Omaha SQL Server Users Group Session
Photo from @sqlrus
Tonight I was lucky enough to be able to present to my home SQL Server Users Group in...
2014-03-06
576 reads
A Community Challenge
Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group.
Among other...
2014-03-05
620 reads
SQL – Backup Report
The simple query to find the database backup status
The select statment consists of
ServerNamedbnameBackupStartDateBackupFinishDateBackupAgeSizestatusTypeThe query will only run from sql 2005...
2014-03-05
507 reads
SQL – Backup Report
The simple query to find the database backup status
The select statment consists of
ServerNamedbnameBackupStartDateBackupFinishDateBackupAgeSizestatusTypeThe query will only run from sql 2005...
2014-03-05
777 reads
SQLSaturday #318 in Orlando on September 27, 2014
Number 8! Our eight annual SQLSaturday in Orlando is coming up on September 27th (note, it’s technically our tenth, but...
2014-03-05
657 reads
Characters you should never ever use in an object or schema name!
You can put pretty much any character you want into an object or schema name by enclosing the name in...
2014-03-05
739 reads
SQL Server Data Encryption Options
SQL Server Data Encryption Types
Businesses today have a greater need than ever to protect their data from security breaches. Data...
2014-03-05
3,266 reads
SQL Saturday #277 Richmond – Covering new ground
SQL Saturday has been a fantastic experience for me here in the DC area (I blogged about it here) and...
2014-03-04
599 reads
Book: Expert Cube Development with SSAS Multidimensional Models
Those of you who use SQL Server Analysis Services (SSAS) are likely familiar with the “bible” for designing cubes: Expert Cube...
2014-03-04
2,323 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers