Pro SQL Server 2012 Practices Chapter 18 Review Tuning for Peak Load
I'm on a Book!
Hello Dear Reader, early last year I was asked if I would like to contribute to a...
2013-01-22
911 reads
Guest blog post and whitepaper at VMware on Shadow IT
Yesterday I was featured as a guest on the VMware.com vFabric blog to introduce a whitepaper that I authored on...
2013-01-22
1,011 reads
New Year Aspirations – boB Taylor – MCM
Thanks for agreeing to do this boB. It’s great to be able to interview the Microsoft program manager for the...
2013-01-22
1,895 reads
SQL Server Backup and Recovery Fundamentals Presentation
SQL Server Backup and Recovery Fundamentals – February 5th, 2013 A copy of the recording is available here. Code and slides...
2013-01-22
771 reads
How To Win Career Gold
The start of a new working year is often a time for self reflection. This is a great thing, it’s...
2013-01-22
1,062 reads
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I’ve used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
828 reads
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I've used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
2,489 reads
SQL Server Views
This post is first of yet to come long series on basic concepts of SQL Server. I’ll begin with basic...
2013-01-22
801 reads
sp_PerformanceCounters - Get a Health Check of SQL Server's Performance
During your career as a DBA, you'll run across articles by SQL experts or other DBAs that just give you...
2013-01-22
1,362 reads
Power View Matrix Drill Capabilities
The features and capabilities of Power View have definitely improved since its release. One of my favorite features is the...
2013-01-21
3,736 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers