Pages
- 31 Days of Disaster Recovery eBook August 6, 2017
- About Us August 26, 2017
- All Groups October 7, 2017
- Become a Contributor September 7, 2017
- Best Practices Ask Question November 11, 2017
- Best Practices Questions November 11, 2017
- Cart August 21, 2017
- Checkout August 21, 2017
- Purchase Confirmation August 21, 2017
- Purchase History August 21, 2017
- Transaction Failed August 21, 2017
- Checkout August 21, 2017
- Client Dashboard August 31, 2017
- Forgot Password October 7, 2017
- Group October 7, 2017
- Invoice August 31, 2017
- Login October 7, 2017
- My account August 21, 2017
- My Account October 4, 2017
- My Profile October 7, 2017
- Partner With Us September 7, 2017
- Past Newsletters August 30, 2017
- Question Archive October 4, 2017
- Registration October 7, 2017
- Reset Password Form October 7, 2017
- Shop August 21, 2017
- Sitemap August 24, 2017
- Vembu Technologies December 28, 2017
- Whitepapers August 26, 2017
Posts
- Audit
- Audit Logons with Extended Events April 27, 2020
- Design
- Stop Bad Database Design January 2, 2012
- 5 Tips for Friday: Naming Conventions November 24, 2017
- Development
- T-SQL Tuesday #005 – Changing Your Isolation Level April 13, 2010
- Are You Putting Out?–The SQL OUTPUT Clause January 31, 2011
- T-SQL Tuesday #18–CTE A Simpler Form Of Recursion May 10, 2011
- Developing To Specifications March 25, 2013
- Best practice recommendations for writing Dynamic SQL June 12, 2013
- Grody to the VARCHAR(MAX) November 21, 2013
- ISNULL & Data Length Handling June 26, 2015
- BCP and Code Page Fun November 2, 2015
- Coding Naked August 21, 2017
- Necessity is the Mother of Automation October 25, 2017
- 5 Tips for Friday: Naming Conventions November 24, 2017
- Disaster Recovery
- T-SQL Tuesday #19–What A Disaster June 14, 2011
- Optimizing Database Restores September 26, 2011
- The Kind of DBA I Want to Be January 22, 2012
- Backup and Recovery February 22, 2012
- Saturday SQL Schoolhouse in Honor of World Backup Day March 31, 2012
- Good Best Practice Advice from the Pensacola Pre-Con June 11, 2012
- Generic Database Restores June 12, 2012
- DBA Best Practices – A Blog Series: Episode 1 – Backups November 16, 2012
- Corruption and Verifying Backups November 26, 2012
- Who Owns SQL Backups? January 10, 2014
- DBA: Guardian of the Data January 16, 2014
- Managing Backup Issues in Availability Groups January 10, 2017
- What is COPY_ONLY? January 16, 2017
- Integrity Checks are Useless* February 13, 2017
- SQL maintenance is a lifecycle, not an event! March 9, 2017
- Distinguish backup file names or pay the price! April 17, 2017
- Why shouldn’t I shrink my database log file? May 15, 2017
- Your Service Level Agreement is a Disaster August 3, 2017
- SQL Server on Linux Series: Backing up over the network August 8, 2017
- 31 Days of Disaster Recovery Revisited August 18, 2017
- Checklist: DR Plan Sanity Check September 4, 2017
- Quiz: How well do you know Recovery best practices? September 11, 2017
- PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed September 15, 2017
- 5 Tips for Friday: Transaction Log September 22, 2017
- Closing all of the connections to a database November 27, 2017
- 5 Tips for Friday: Database Corruption December 15, 2017
- What’s the difference between Files and Filegroups? March 28, 2018
- Debugging techniques (focusing on T-SQL) April 2, 2020
- Blogging and coding best practices April 3, 2020
- Audit Database Offline Events April 6, 2020
- SQL is offline for 10 minutes this week. Meanwhile, this article takes 5 minutes to read. March 7, 2022
- Extended Events
- Audit Logons with Extended Events April 27, 2020
- General BP
- Moving the Master Database Lesson Learned December 6, 2011
- Microsoft RAP, Not Just Clever Lyrics January 19, 2012
- Why We Follow Best Practices February 26, 2012
- Refreshing Development Databases March 5, 2012
- Back In the Saddle Again March 12, 2012
- Best Practicing, the Results Part I March 20, 2012
- I Am Passionate About Best Practices April 11, 2012
- Something Technical This Way Comes April 18, 2012
- The Importance Of Good Documentation April 24, 2012
- SQL Rally 2012 Recap and Session Files May 15, 2012
- Vendor Support–The Good And Bad May 29, 2012
- Final Thought from SQL Saturday Pensacola Pre-Con June 15, 2012
- Keeping Track of Details September 25, 2012
- DBA Best Practices: A Blog Series November 13, 2012
- Fun With Recruiters November 13, 2012
- Shrink That Database…Seriously? November 28, 2012
- DBA Best Practices – A Blog Series: Episode 2 – Password Lists November 30, 2012
- DBA Best Practices – A Blog Series: Episode 3 – Use a Wiki for Documentation February 13, 2013
- Best Advice Ever: Learn By Helping Others October 25, 2013
- You Have One Job November 23, 2015
- Re-Evaluating Best Practices May 18, 2016
- The Right Way To Attend PASS Summit October 7, 2016
- The Costs of Hiring Cheaper Consultants February 17, 2017
- Event storming! It’s raining emails! March 1, 2017
- Limits vs Goals March 14, 2017
- Updated SQL Server on VMware Best Practices Guide March 23, 2017
- Turning ANSI_PADDING off, and why you shouldn’t June 15, 2017
- Coding Naked August 21, 2017
- Checklist: DR Plan Sanity Check September 4, 2017
- Do what I say, not what I do September 20, 2017
- 5 Tips for Friday: Deployments October 20, 2017
- When is it a good idea to consolidate multiple instances? October 23, 2017
- Necessity is the Mother of Automation October 25, 2017
- Three big reasons T-SQL still beats the GUI April 23, 2020
- These five SQL tools are essential for 2020 April 24, 2020
- The default filegroup, and why you should care. May 27, 2020
- Work requests: It’s broke. Fix it. April 13, 2022
- High Availability
- SQL Clustering–Network Binding Order Warnings May 12, 2011
- Your “Five Nines” Means Nothing To Me November 18, 2011
- Removing a Perfectly Good Cluster, Part Two June 5, 2012
- Automated Backup Tuning December 13, 2012
- You Can’t Meet Your RPO/RTO With AlwaysOn November 5, 2013
- Rolling Upgrades With Availability Groups – A Warning August 4, 2014
- Availability Group WSFC Failovers During VM Movement April 23, 2015
- Availability Groups & Reindexing May 18, 2015
- 5 Tips for Friday: Availability Groups October 6, 2017
- 3 Important Queries for Testing Your Availability Group Endpoints April 14, 2022
- Infrastructure
- Summon Blue Screens of Death (for testing purposes only, of course) November 30, 2015
- Load Testing Results Might Not Be What You Think September 12, 2016
- VMworld EMEA SQL Server Sessions September 5, 2017
- SQL Saturday Minnesota Preconference Training Session September 7, 2017
- Installation/Upgrade/Configuration
- Moving SQL Datafiles June 24, 2010
- SQL Clustering–Network Binding Order Warnings May 12, 2011
- Be Careful Installing Windows Features May 26, 2011
- Configuration Data Best Practice February 10, 2012
- Best Practicing, the Results Part Dos March 21, 2012
- Who Owns Your Databases And Jobs? April 25, 2012
- Good Best Practice Advice from the Pensacola Pre-Con, Round Two June 12, 2012
- Changing SQL Agent Job Subsystem Queue Lengths July 9, 2012
- Lock Pages in Memory in SQL Server on VMware – Why or Why Not November 4, 2013
- Rolling Upgrades With Availability Groups – A Warning August 4, 2014
- FusionIO and the Go Faster Button February 12, 2015
- Patching Master Data Services April 13, 2015
- Enabling IFI on Setup in SQL Server 2016 November 11, 2015
- Why Log Shipping is Better than Database Mirroring for Migrations May 5, 2017
- SQL Server on Linux Series: Operating System Differences May 30, 2017
- SQL Server on Linux Series: Additional Drives July 24, 2017
- SQL Server on Linux Series: Moving TempDB July 27, 2017
- Patching SQL Server and SSMS? Order matters. August 14, 2017
- Quiz: How well do you know SQL Server configuration best practices? August 31, 2017
- 5 Tips for Friday: Upgrades and Migrations September 29, 2017
- When is it a good idea to consolidate multiple instances? October 23, 2017
- Podcast with SQL Data Partners on Patching Best Practices October 23, 2017
- 5 Tips for Friday: Database Configurations October 27, 2017
- Maintenance
- SQL Job Notifications May 12, 2010
- Keeping MSDB Clean January 26, 2011
- Stop Logging Successful Backups April 28, 2011
- Optimizing Database Restores September 26, 2011
- New Year House Cleaning January 3, 2012
- Transaction Log Fills Up the Drive….Oh No! January 10, 2012
- Backup and Recovery February 22, 2012
- Best Practicing? Here’s How! March 19, 2012
- Best Practicing, the Results Part I March 20, 2012
- Proper Backup Alerting December 13, 2016
- Managing Backup Issues in Availability Groups January 10, 2017
- Integrity Checks are Useless* February 13, 2017
- SQL maintenance is a lifecycle, not an event! March 9, 2017
- Distinguish backup file names or pay the price! April 17, 2017
- 5 Tips for Friday: Transaction Log September 22, 2017
- I’m the new DBA, and I’m locking down development servers September 26, 2017
- Podcast with SQL Data Partners on Patching Best Practices October 23, 2017
- Why shouldn’t I shrink my database data file? November 20, 2017
- Closing all of the connections to a database November 27, 2017
- 5 Tips for Friday: Preparing for the Holidays December 8, 2017
- Clumio’s Rapid Recovery is amazing for SQL Server May 21, 2020
- Ten minute SQL Server backup and maintenance May 22, 2020
- All triggers have to be able to handle multiple row operations. September 9, 2020
- Monitoring
- Event storming! It’s raining emails! March 1, 2017
- 5 Tips for Friday: Monitoring and Alerting December 1, 2017
- Audit Logons with Extended Events April 27, 2020
- Automate SQL Server error log alerting with Minion Enterprise May 25, 2020
- Performance Tuning
- What Indexes Are Not Being Used And How Big Are They? July 9, 2010
- The Barking Dog Analogy September 20, 2011
- Breaking Down TempDB Contention (part 2) January 30, 2012
- Clustered Nuts? February 21, 2012
- Optimizing TempDB Performance February 23, 2012
- Whitepaper: Demystify Tempdb Performance & Management March 20, 2012
- SQL Server 2012 on VMware vSphere March 26, 2012
- Good Best Practice Advice from the Pensacola Pre-Con June 11, 2012
- Good Best Practice Advice from the Pensacola Pre-Con, Round Two June 12, 2012
- Green? If You Only Knew the Power of the Dark Side! June 14, 2012
- Shrink That Database…Seriously? November 28, 2012
- CPU Overcommitment and Its Impact on SQL Server Performance on VMware December 17, 2012
- Network Packet Size: to Fiddle With or Not to Fiddle With March 27, 2013
- Grody to the VARCHAR(MAX) November 21, 2013
- Performance Counters: Why It Depends August 18, 2014
- Improving Performance When Querying Multiple DMVs October 29, 2014
- FusionIO and the Go Faster Button February 12, 2015
- VMware CPU Co-Stop and SQL Server Performance March 3, 2016
- VMware CPU Co-Stop and SQL Server Performance (continued) April 18, 2016
- RBAR vs Batch August 17, 2016
- Too Many Indexes? October 13, 2016
- What Really Causes Performance Problems? December 5, 2016
- Queries with optional parameters February 27, 2017
- Using GROUP BY instead of DISTINCT March 6, 2017
- When should I add an index? April 19, 2017
- VMworld EMEA SQL Server Sessions September 5, 2017
- SQL Server on VMware VMworld USA Videos Now On YouTube September 6, 2017
- SQL Saturday Minnesota Preconference Training Session September 7, 2017
- PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed September 15, 2017
- 5 Tips for Friday: Query Tuning September 16, 2017
- 5 Tips for Friday: Transaction Log September 22, 2017
- Which is the performance killer: SELECT INTO or INSERT INTO? October 25, 2017
- 5 Tips for Friday: Massively Parallel Queries November 3, 2017
- 5 Tips for Friday: Waits and Queues November 17, 2017
- Why shouldn’t I shrink my database data file? November 20, 2017
- Time Zones are a Drag … Seriously November 24, 2017
- What are you tuning for? May 29, 2020
- PowerShell
- Changing SQL Agent Job Subsystem Queue Lengths July 9, 2012
- Passing SQL Data To Command Line Processes Within SQL Jobs July 18, 2012
- Automated Backup Tuning December 13, 2012
- T-SQLTuesday #94: Using Invoke-SQLCmd to run SQL Jobs Remotely September 12, 2017
- Necessity is the Mother of Automation October 25, 2017
- Professional Development
- T-SQL Tuesday #13–A Mysterious Business December 14, 2010
- How To Interview–A Quick Guide May 24, 2011
- Un-SQL Friday #004–Speakers First Rule June 8, 2011
- Speakers Second Rule June 10, 2011
- Speakers Third Rule June 13, 2011
- Be A Courteous Blogger June 28, 2011
- The Kind of DBA I Want to Be January 22, 2012
- The Loneliness of the On Call DBA February 14, 2012
- T-SQL Tuesday #028 – Jack of All Trades, Master of None? March 5, 2012
- Presentation Ponderings July 10, 2012
- I Survived! September 29, 2012
- Is Technical Writing Important? November 28, 2012
- Best Advice Ever: Learn By Helping Others October 25, 2013
- When DMVs Cost Me My Job December 27, 2013
- On Community and Recognition July 1, 2014
- You Have One Job November 23, 2015
- Q&A: Multiple SQL Server Instances on a VM January 18, 2016
- Who Needs a DBA? April 11, 2017
- DBA as a Commodity May 15, 2017
- T-SQL Tuesday #93: 3 Jobs I Didn’t Take and 1 I did August 8, 2017
- How To Not Be a Commodity DBA – Part 1 August 25, 2017
- Pay Yourself First August 29, 2017
- SQL Server on VMware VMworld USA Videos Now On YouTube September 6, 2017
- Q&A Session with SQL Server on VMware Experts at VMworld EMEA September 7, 2017
- SQL Saturday Minnesota Preconference Training Session September 7, 2017
- PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed September 15, 2017
- 5 Tips for Friday: Public Speaking October 13, 2017
- Quizzes
- Quiz: How well do you know SQL Server configuration best practices? August 31, 2017
- Quiz: How well do you know Recovery best practices? September 11, 2017
- Quiz: How well do you know security best practices? October 9, 2017
- Replication
- Calculating Replication Schema Options September 10, 2010
- T-SQL Tuesday #10 – Applying Indexes To Replicated Tables September 14, 2010
- Mass Updating Job Step Retry Attempts February 8, 2012
- Replication–Beware Reuse of View Names When Filtering Articles February 27, 2012
- New Whitepaper: Deciding Between Merge and Peer-to-Peer Replication October 21, 2015
- 5 Tips for Friday: Replication November 10, 2017
- Security
- Fun With Windows Logins In SQL February 22, 2011
- Hardening SQL Server June 23, 2011
- Good Best Practice Advice from the Pensacola Pre-Con June 11, 2012
- Good Best Practice Advice from the Pensacola Pre-Con, Round Two June 12, 2012
- AD Accounts Are Great, But… July 16, 2012
- How Do You Provide Passwords To Your Users? August 8, 2012
- Keeping Track of Details September 25, 2012
- Do You Trust Your Application Admins? October 23, 2012
- Is it safe to grant Administer Bulk Operations? November 10, 2016
- What Really Causes Performance Problems? December 5, 2016
- Why is a Windows authenticated login more secure than a SQL authenticated one? April 26, 2017
- 5 Tips for Friday: Security September 8, 2017
- I’m the new DBA, and I’m locking down development servers September 26, 2017
- Quiz: How well do you know security best practices? October 9, 2017
- Restrict the usage of a SQL Server Authenticated Application Id December 6, 2017
- Audit Logons with Extended Events April 27, 2020
- UNDERSTANDING SQL SERVER SECURITY: Secure xp_cmdshell with the Microsoft Master’s guide (in 4 not-so-easy steps) April 8, 2022
- SQL Server Security on the Ground April 13, 2022
- Dear Leadership: your SQL security stinks April 15, 2022
- SQL Server
- T-SQL Tuesday #005 – Changing Your Isolation Level April 13, 2010
- SQL Job Notifications May 12, 2010
- Moving SQL Datafiles June 24, 2010
- What Indexes Are Not Being Used And How Big Are They? July 9, 2010
- Calculating Replication Schema Options September 10, 2010
- T-SQL Tuesday #10 – Applying Indexes To Replicated Tables September 14, 2010
- T-SQL Tuesday #13–A Mysterious Business December 14, 2010
- Keeping MSDB Clean January 26, 2011
- Are You Putting Out?–The SQL OUTPUT Clause January 31, 2011
- Fun With Windows Logins In SQL February 22, 2011
- Adding LUNs In VMware – A Cautionary Tale April 7, 2011
- Stop Logging Successful Backups April 28, 2011
- T-SQL Tuesday #18–CTE A Simpler Form Of Recursion May 10, 2011
- SQL Clustering–Network Binding Order Warnings May 12, 2011
- How To Interview–A Quick Guide May 24, 2011
- Be Careful Installing Windows Features May 26, 2011
- Un-SQL Friday #004–Speakers First Rule June 8, 2011
- Speakers Second Rule June 10, 2011
- Speakers Third Rule June 13, 2011
- T-SQL Tuesday #19–What A Disaster June 14, 2011
- Hardening SQL Server June 23, 2011
- Be A Courteous Blogger June 28, 2011
- The Barking Dog Analogy September 20, 2011
- Optimizing Database Restores September 26, 2011
- Your “Five Nines” Means Nothing To Me November 18, 2011
- Moving the Master Database Lesson Learned December 6, 2011
- Please Don’t Use Deprecated Data Types December 15, 2011
- Stop Bad Database Design January 2, 2012
- New Year House Cleaning January 3, 2012
- Transaction Log Fills Up the Drive….Oh No! January 10, 2012
- xp_logininfo–Your View Into Active Directory January 11, 2012
- Microsoft RAP, Not Just Clever Lyrics January 19, 2012
- The Kind of DBA I Want to Be January 22, 2012
- Breaking Down TempDB Contention (part 2) January 30, 2012
- Mass Updating Job Step Retry Attempts February 8, 2012
- Configuration Data Best Practice February 10, 2012
- The Loneliness of the On Call DBA February 14, 2012
- Saturday SQL Schoolhouse February 18, 2012
- Clustered Nuts? February 21, 2012
- Backup and Recovery February 22, 2012
- Optimizing TempDB Performance February 23, 2012
- Why We Follow Best Practices February 26, 2012
- Replication–Beware Reuse of View Names When Filtering Articles February 27, 2012
- T-SQL Tuesday #028 – Jack of All Trades, Master of None? March 5, 2012
- Refreshing Development Databases March 5, 2012
- Back In the Saddle Again March 12, 2012
- Best Practicing? Here’s How! March 19, 2012
- Whitepaper: Demystify Tempdb Performance & Management March 20, 2012
- Best Practicing, the Results Part I March 20, 2012
- Best Practicing, the Results Part Dos March 21, 2012
- SQL Server 2012 on VMware vSphere March 26, 2012
- Saturday SQL Schoolhouse in Honor of World Backup Day March 31, 2012
- I Am Passionate About Best Practices April 11, 2012
- Something Technical This Way Comes April 18, 2012
- The Importance Of Good Documentation April 24, 2012
- Who Owns Your Databases And Jobs? April 25, 2012
- SQL Rally 2012 Recap and Session Files May 15, 2012
- Vendor Support–The Good And Bad May 29, 2012
- Removing a Perfectly Good Cluster, Part Two June 5, 2012
- Good Best Practice Advice from the Pensacola Pre-Con June 11, 2012
- Generic Database Restores June 12, 2012
- Good Best Practice Advice from the Pensacola Pre-Con, Round Two June 12, 2012
- Green? If You Only Knew the Power of the Dark Side! June 14, 2012
- Final Thought from SQL Saturday Pensacola Pre-Con June 15, 2012
- Changing SQL Agent Job Subsystem Queue Lengths July 9, 2012
- Presentation Ponderings July 10, 2012
- AD Accounts Are Great, But… July 16, 2012
- Passing SQL Data To Command Line Processes Within SQL Jobs July 18, 2012
- How Do You Provide Passwords To Your Users? August 8, 2012
- Extended Properties Are Your Friend August 28, 2012
- Why Your DBAs Need Access to VMware vCenter September 7, 2012
- Keeping Track of Details September 25, 2012
- I Survived! September 29, 2012
- Do You Trust Your Application Admins? October 23, 2012
- DBA Best Practices: A Blog Series November 13, 2012
- Fun With Recruiters November 13, 2012
- DBA Best Practices – A Blog Series: Episode 1 – Backups November 16, 2012
- Corruption and Verifying Backups November 26, 2012
- Shrink That Database…Seriously? November 28, 2012
- Is Technical Writing Important? November 28, 2012
- DBA Best Practices – A Blog Series: Episode 2 – Password Lists November 30, 2012
- Automated Backup Tuning December 13, 2012
- CPU Overcommitment and Its Impact on SQL Server Performance on VMware December 17, 2012
- DBA Best Practices – A Blog Series: Episode 3 – Use a Wiki for Documentation February 13, 2013
- Developing To Specifications March 25, 2013
- Network Packet Size: to Fiddle With or Not to Fiddle With March 27, 2013
- Best practice recommendations for writing Dynamic SQL June 12, 2013
- Best Advice Ever: Learn By Helping Others October 25, 2013
- Lock Pages in Memory in SQL Server on VMware – Why or Why Not November 4, 2013
- You Can’t Meet Your RPO/RTO With AlwaysOn November 5, 2013
- Grody to the VARCHAR(MAX) November 21, 2013
- SQL Server Virtual Machine vNUMA Sizing December 2, 2013
- When DMVs Cost Me My Job December 27, 2013
- Who Owns SQL Backups? January 10, 2014
- DBA: Guardian of the Data January 16, 2014
- On Community and Recognition July 1, 2014
- Rolling Upgrades With Availability Groups – A Warning August 4, 2014
- Performance Counters: Why It Depends August 18, 2014
- Improving Performance When Querying Multiple DMVs October 29, 2014
- FusionIO and the Go Faster Button February 12, 2015
- Patching Master Data Services April 13, 2015
- Availability Group WSFC Failovers During VM Movement April 23, 2015
- Availability Groups & Reindexing May 18, 2015
- ISNULL & Data Length Handling June 26, 2015
- New Whitepaper: Deciding Between Merge and Peer-to-Peer Replication October 21, 2015
- BCP and Code Page Fun November 2, 2015
- Enabling IFI on Setup in SQL Server 2016 November 11, 2015
- You Have One Job November 23, 2015
- Q&A: Multiple SQL Server Instances on a VM January 18, 2016
- VMware CPU Co-Stop and SQL Server Performance March 3, 2016
- VMware CPU Co-Stop and SQL Server Performance (continued) April 18, 2016
- Re-Evaluating Best Practices May 18, 2016
- RBAR vs Batch August 17, 2016
- The Right Way To Attend PASS Summit October 7, 2016
- Too Many Indexes? October 13, 2016
- Is it safe to grant Administer Bulk Operations? November 10, 2016
- VMware vSphere 6.5 breaks your SQL Server vNUMA settings November 29, 2016
- What Really Causes Performance Problems? December 5, 2016
- Proper Backup Alerting December 13, 2016
- Managing Backup Issues in Availability Groups January 10, 2017
- What is COPY_ONLY? January 16, 2017
- Integrity Checks are Useless* February 13, 2017
- The Costs of Hiring Cheaper Consultants February 17, 2017
- Queries with optional parameters February 27, 2017
- Event storming! It’s raining emails! March 1, 2017
- Using GROUP BY instead of DISTINCT March 6, 2017
- SQL maintenance is a lifecycle, not an event! March 9, 2017
- Limits vs Goals March 14, 2017
- Updated SQL Server on VMware Best Practices Guide March 23, 2017
- Who Needs a DBA? April 11, 2017
- Distinguish backup file names or pay the price! April 17, 2017
- When should I add an index? April 19, 2017
- Why is a Windows authenticated login more secure than a SQL authenticated one? April 26, 2017
- Why Log Shipping is Better than Database Mirroring for Migrations May 5, 2017
- Dynamic SQL and the joys of QUOTENAME May 11, 2017
- DBA as a Commodity May 15, 2017
- Why shouldn’t I shrink my database log file? May 15, 2017
- SQL Server on Linux Series: Operating System Differences May 30, 2017
- Turning ANSI_PADDING off, and why you shouldn’t June 15, 2017
- SQL Server on Linux Series: Additional Drives July 24, 2017
- SQL Server on Linux Series: Moving TempDB July 27, 2017
- Your Service Level Agreement is a Disaster August 3, 2017
- T-SQL Tuesday #93: 3 Jobs I Didn’t Take and 1 I did August 8, 2017
- SQL Server on Linux Series: Backing up over the network August 8, 2017
- Patching SQL Server and SSMS? Order matters. August 14, 2017
- 31 Days of Disaster Recovery Revisited August 18, 2017
- Coding Naked August 21, 2017
- VMworld 2017 SQL Server Sessions August 23, 2017
- How To Not Be a Commodity DBA – Part 1 August 25, 2017
- SQLBP Monthly #1 August 29, 2017
- Pay Yourself First August 29, 2017
- Quiz: How well do you know SQL Server configuration best practices? August 31, 2017
- Checklist: DR Plan Sanity Check September 4, 2017
- VMworld EMEA SQL Server Sessions September 5, 2017
- SQL Server on VMware VMworld USA Videos Now On YouTube September 6, 2017
- Q&A Session with SQL Server on VMware Experts at VMworld EMEA September 7, 2017
- SQL Saturday Minnesota Preconference Training Session September 7, 2017
- 5 Tips for Friday: Security September 8, 2017
- Quiz: How well do you know Recovery best practices? September 11, 2017
- T-SQLTuesday #94: Using Invoke-SQLCmd to run SQL Jobs Remotely September 12, 2017
- PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed September 15, 2017
- 5 Tips for Friday: Query Tuning September 16, 2017
- Do what I say, not what I do September 20, 2017
- 5 Tips for Friday: Transaction Log September 22, 2017
- I’m the new DBA, and I’m locking down development servers September 26, 2017
- 5 Tips for Friday: Upgrades and Migrations September 29, 2017
- The Alpha and the Omega. The BEGIN and the END. October 4, 2017
- 5 Tips for Friday: Availability Groups October 6, 2017
- SQLBP Monthly #2 October 6, 2017
- Quiz: How well do you know security best practices? October 9, 2017
- Small identity columns October 9, 2017
- sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc) October 11, 2017
- 5 Tips for Friday: Public Speaking October 13, 2017
- 5 Tips for Friday: Deployments October 20, 2017
- When is it a good idea to consolidate multiple instances? October 23, 2017
- Podcast with SQL Data Partners on Patching Best Practices October 23, 2017
- Which is the performance killer: SELECT INTO or INSERT INTO? October 25, 2017
- Necessity is the Mother of Automation October 25, 2017
- 5 Tips for Friday: Database Configurations October 27, 2017
- 5 Tips for Friday: Massively Parallel Queries November 3, 2017
- 5 Tips for Friday: Replication November 10, 2017
- 5 Tips for Friday: Waits and Queues November 17, 2017
- Why shouldn’t I shrink my database data file? November 20, 2017
- Time Zones are a Drag … Seriously November 24, 2017
- 5 Tips for Friday: Naming Conventions November 24, 2017
- Closing all of the connections to a database November 27, 2017
- 5 Tips for Friday: Monitoring and Alerting December 1, 2017
- Restrict the usage of a SQL Server Authenticated Application Id December 6, 2017
- 5 Tips for Friday: Preparing for the Holidays December 8, 2017
- 5 Tips for Friday: Database Corruption December 15, 2017
- What’s the difference between Files and Filegroups? March 28, 2018
- Debugging techniques (focusing on T-SQL) April 2, 2020
- Blogging and coding best practices April 3, 2020
- Audit Database Offline Events April 6, 2020
- Three big reasons T-SQL still beats the GUI April 23, 2020
- These five SQL tools are essential for 2020 April 24, 2020
- Audit Logons with Extended Events April 27, 2020
- Clumio’s Rapid Recovery is amazing for SQL Server May 21, 2020
- Ten minute SQL Server backup and maintenance May 22, 2020
- Automate SQL Server error log alerting with Minion Enterprise May 25, 2020
- The default filegroup, and why you should care. May 27, 2020
- What are you tuning for? May 29, 2020
- All triggers have to be able to handle multiple row operations. September 9, 2020
- SQL is offline for 10 minutes this week. Meanwhile, this article takes 5 minutes to read. March 7, 2022
- UNDERSTANDING SQL SERVER SECURITY: Secure xp_cmdshell with the Microsoft Master’s guide (in 4 not-so-easy steps) April 8, 2022
- Work requests: It’s broke. Fix it. April 13, 2022
- SQL Server Security on the Ground April 13, 2022
- 3 Important Queries for Testing Your Availability Group Endpoints April 14, 2022
- Dear Leadership: your SQL security stinks April 15, 2022
- Storage
- Adding LUNs In VMware – A Cautionary Tale April 7, 2011
- New Year House Cleaning January 3, 2012
- Saturday SQL Schoolhouse February 18, 2012
- Q&A Session with SQL Server on VMware Experts at VMworld EMEA September 7, 2017
- SQL Saturday Minnesota Preconference Training Session September 7, 2017
- PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed September 15, 2017
- T-SQL
- T-SQL Tuesday #10 – Applying Indexes To Replicated Tables September 14, 2010
- Are You Putting Out?–The SQL OUTPUT Clause January 31, 2011
- T-SQL Tuesday #18–CTE A Simpler Form Of Recursion May 10, 2011
- Please Don’t Use Deprecated Data Types December 15, 2011
- Stop Bad Database Design January 2, 2012
- xp_logininfo–Your View Into Active Directory January 11, 2012
- Mass Updating Job Step Retry Attempts February 8, 2012
- Replication–Beware Reuse of View Names When Filtering Articles February 27, 2012
- Who Owns Your Databases And Jobs? April 25, 2012
- Generic Database Restores June 12, 2012
- Passing SQL Data To Command Line Processes Within SQL Jobs July 18, 2012
- Extended Properties Are Your Friend August 28, 2012
- Best practice recommendations for writing Dynamic SQL June 12, 2013
- Improving Performance When Querying Multiple DMVs October 29, 2014
- ISNULL & Data Length Handling June 26, 2015
- RBAR vs Batch August 17, 2016
- Too Many Indexes? October 13, 2016
- Dynamic SQL and the joys of QUOTENAME May 11, 2017
- Do what I say, not what I do September 20, 2017
- I’m the new DBA, and I’m locking down development servers September 26, 2017
- The Alpha and the Omega. The BEGIN and the END. October 4, 2017
- Small identity columns October 9, 2017
- sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc) October 11, 2017
- 5 Tips for Friday: Deployments October 20, 2017
- Which is the performance killer: SELECT INTO or INSERT INTO? October 25, 2017
- 5 Tips for Friday: Massively Parallel Queries November 3, 2017
- Time Zones are a Drag … Seriously November 24, 2017
- 5 Tips for Friday: Naming Conventions November 24, 2017
- Closing all of the connections to a database November 27, 2017
- 3 Important Queries for Testing Your Availability Group Endpoints April 14, 2022
- Virtualization
- Adding LUNs In VMware – A Cautionary Tale April 7, 2011
- SQL Server 2012 on VMware vSphere March 26, 2012
- Why Your DBAs Need Access to VMware vCenter September 7, 2012
- Create a portable virtual machine with OVF or OVA October 3, 2012
- CPU Overcommitment and Its Impact on SQL Server Performance on VMware December 17, 2012
- Lock Pages in Memory in SQL Server on VMware – Why or Why Not November 4, 2013
- SQL Server Virtual Machine vNUMA Sizing December 2, 2013
- Retrofit a VM with the VMware Paravirtual SCSI Driver January 8, 2014
- Availability Group WSFC Failovers During VM Movement April 23, 2015
- Summon Blue Screens of Death (for testing purposes only, of course) November 30, 2015
- Q&A: Multiple SQL Server Instances on a VM January 18, 2016
- VMware CPU Co-Stop and SQL Server Performance March 3, 2016
- VMware CPU Co-Stop and SQL Server Performance (continued) April 18, 2016
- Load Testing Results Might Not Be What You Think September 12, 2016
- VMware vSphere 6.5 breaks your SQL Server vNUMA settings November 29, 2016
- VMware Updates In-Guest Clocks When You Say Not To March 6, 2017
- Updated SQL Server on VMware Best Practices Guide March 23, 2017
- Keep VMware snapshot growth from wrecking your day June 26, 2017
- New Whitepaper – Capture Production Error States August 21, 2017
- VMworld 2017 SQL Server Sessions August 23, 2017
- VMworld EMEA SQL Server Sessions September 5, 2017
- SQL Server on VMware VMworld USA Videos Now On YouTube September 6, 2017
- Q&A Session with SQL Server on VMware Experts at VMworld EMEA September 7, 2017
- SQL Saturday Minnesota Preconference Training Session September 7, 2017
- PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed September 15, 2017
- What are you tuning for? May 29, 2020
- VMWare
- Adding LUNs In VMware – A Cautionary Tale April 7, 2011
- SQL Server 2012 on VMware vSphere March 26, 2012
- Why Your DBAs Need Access to VMware vCenter September 7, 2012
- Create a portable virtual machine with OVF or OVA October 3, 2012
- CPU Overcommitment and Its Impact on SQL Server Performance on VMware December 17, 2012
- Lock Pages in Memory in SQL Server on VMware – Why or Why Not November 4, 2013
- Retrofit a VM with the VMware Paravirtual SCSI Driver January 8, 2014
- VMware CPU Co-Stop and SQL Server Performance March 3, 2016
- VMware CPU Co-Stop and SQL Server Performance (continued) April 18, 2016
- VMware vSphere 6.5 breaks your SQL Server vNUMA settings November 29, 2016
- VMware Updates In-Guest Clocks When You Say Not To March 6, 2017
- Updated SQL Server on VMware Best Practices Guide March 23, 2017
- Keep VMware snapshot growth from wrecking your day June 26, 2017
- New Whitepaper – Capture Production Error States August 21, 2017
- VMworld 2017 SQL Server Sessions August 23, 2017
- VMworld EMEA SQL Server Sessions September 5, 2017
- SQL Server on VMware VMworld USA Videos Now On YouTube September 6, 2017
- Q&A Session with SQL Server on VMware Experts at VMworld EMEA September 7, 2017
- vSphere
- Create a portable virtual machine with OVF or OVA October 3, 2012
- VMware vSphere 6.5 breaks your SQL Server vNUMA settings November 29, 2016
- Keep VMware snapshot growth from wrecking your day June 26, 2017
- New Whitepaper – Capture Production Error States August 21, 2017
- VMworld EMEA SQL Server Sessions September 5, 2017
Archives
- April 2022 (5)
- March 2022 (1)
- September 2020 (1)
- May 2020 (5)
- April 2020 (6)
- March 2018 (1)
- December 2017 (4)
- November 2017 (7)
- October 2017 (13)
- September 2017 (14)
- August 2017 (12)
- July 2017 (2)
- June 2017 (2)
- May 2017 (5)
- April 2017 (4)
- March 2017 (6)
- February 2017 (3)
- January 2017 (2)
- December 2016 (2)
- November 2016 (2)
- October 2016 (2)
- September 2016 (1)
- August 2016 (1)
- May 2016 (1)
- April 2016 (1)
- March 2016 (1)
- January 2016 (1)
- November 2015 (4)
- October 2015 (1)
- June 2015 (1)
- May 2015 (1)
- April 2015 (2)
- February 2015 (1)
- October 2014 (1)
- August 2014 (2)
- July 2014 (1)
- January 2014 (3)
- December 2013 (2)
- November 2013 (3)
- October 2013 (1)
- June 2013 (1)
- March 2013 (2)
- February 2013 (1)
- December 2012 (2)
- November 2012 (7)
- October 2012 (2)
- September 2012 (3)
- August 2012 (2)
- July 2012 (4)
- June 2012 (6)
- May 2012 (2)
- April 2012 (4)
- March 2012 (9)
- February 2012 (9)
- January 2012 (7)
- December 2011 (2)
- November 2011 (1)
- September 2011 (2)
- June 2011 (6)
- May 2011 (4)
- April 2011 (2)
- February 2011 (1)
- January 2011 (2)
- December 2010 (1)
- September 2010 (2)
- July 2010 (1)
- June 2010 (1)
- May 2010 (1)
- April 2010 (1)
Categories
Audit Design Development Disaster Recovery Extended Events General BP High Availability Infrastructure Installation/Upgrade/Configuration Maintenance Monitoring Performance Tuning PowerShell Professional Development Quizzes Replication Security SQL Server Storage T-SQL Virtualization VMWare vSphere