From the SQL Server blogs

• Tip # 8 – Default TempDB Settings – Chris Shaw(Blog|Twitter)
• A first look at Redgate Reference Data Manager – Dave Ballantyne (Blog|Twitter)
• How to See the Secret Columns In Your Indexes –  Brent Ozar (Blog|Twitter)
• Restoring a Database in Azure – Grant Fritchey (Blog|Twitter)
• How to Talk People Out of the SA Account, Option 1 – Brent Ozar (Blog|Twitter)
• Join Effects With UPDATE – Rob Farley (Blog|Twitter)
• Cheat Sheet: How to Configure TempDB for Microsoft SQL Server – Brent Ozar (Blog|Twitter)
• Useful Whitepapers for Planning SQL Server Migrations – Kendra Little (Blog|Twitter)
• Stop using Task Manager to check SQL’s memory usage! – Gail Shaw (Blog|Twitter)
• How to Find Missing Index Requests in Query Store – Kendra Little (Blog|Twitter)
• Cursor Statistics Are Missing in dm_exec_query_stats – Michael J. Swart (Blog|Twitter)
• Removing All SQL Server Query Store Data – Grant Fritchey (Blog|Twitter)
• 3 Things I Wish I’d Learned Earlier as a SQL Server DBA – Kendra Little (Blog|Twitter)

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• SQLQueryStress: The Source Code – Adam Machanic (Blog|Twitter)
• Does index fill factor affect fragmentation? –  Erik Darling (Blog|Twitter)
• Still Serial After All These Years – Erik Darling (Blog|Twitter)
• A warning about Diagnostic Manager’s Query Monitor Feature in v9+ – Jonathan Kehayias (Blog|Twitter)
• Change The Compatibility Level Of Azure Sql Database – Thomas Larock (Blog|Twitter)
• The Hardest Thing In Data Science – Buck Woody (Blog|Twitter)
• Super Scaling Queues Using the LMax Disruptor Pattern – Chris Adkin (Blog|Twitter)
• What to do when you run out of disk space for In-Memory OLTP checkpoint files – CSS SQL Server Engineers (Blog)
• Why Teaching Makes You a Better DBA and Performance Tuner – Kendra Little (Blog|Twitter)  

If you have a content suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• Reporting on SQL Agent Jobs with #Powershell – Mike Fal (Blog|Twitter)
• What’s driving your data model? – Rob Farley (Blog|Twitter)
• In-Memory OLTP – what’s new in SQL2016 CTP3 – SQL Server DB Engine (Blog)
• Why is SQL Server Slow Sometimes – But Only Sometimes? – Brent Ozar (Blog|Twitter)
• Are My Statistics Correct? – CSS SQL Server Engineers (Blog)
• Did My Query Eliminate Table Partitions in SQL Server? – Kendra Little (Blog|Twitter)
• Savepoints and conditional transactions – Gail Shaw (Blog|Twitter)
• Is My SQL Server Too Big for Virtualization or the Cloud? – Brent Ozar (Blog|Twitter)
• Troubleshooting The process could not execute ‘sp_repldone’ – MSFT Replication(Blog)
• Will SQL Server use ‘incomplete’ or ‘dirty’ statistics – CSS SQL Server Engineers (Blog)

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• Low priority locking wait types – Paul Randal (Blog|Twitter)
• A Mess of Nested Transactions – Gail Shaw (Blog|Twitter)
• DROP IF EXISTS – new thing in SQL Server 2016 – SQL Server DB Engine (Blog)
• Anti Scale Patterns and The Repartition Streams Iterator In Row Mode – Chris Adkin (Blog|Twitter)
• Interviewing: How to Test TSQL Writing Skills – Kendra Little (Blog|Twitter)
• OPENJSON – one of best ways to select rows by list of ids – SQL Server DB Engine (Blog)
• How to prevent SELECT * statements – Klaus Aschenbrenner (Blog|Twitter)
• On index key size, index depth, and performance – Paul Randal (Blog|Twitter)
• Of clustered indexes and ordering – Gail Shaw (Blog|Twitter)

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• Index selectivity and index scans – Gail Shaw (Blog|Twitter)
• Improve Database Performance Without Changing Code – Thomas Larock (Blog|Twitter)
• Make Technical Decisions Easily With This One Trick – Jeremiah Peschka (Blog|Twitter)
• Importing JSON files into SQL Server – SQL Server DB Engine (Blog)
• AlwaysOn AG Databases Need Bigger Log Files – Brent Ozar (Blog|Twitter)
• Don’t Abandon Your Transactions – Michael J. Swart (Blog|Twitter)
• Deciding Between Merge and Peer-to-Peer Replication – Robert L. Davis(Blog|Twitter)
• ReplTip – Breakout by Article – Microsoft SQL Server Replication Support Team(Blog)
• Training Plan for a SysAdmin to Manage Availability Groups – Kendra Little (Blog|Twitter)
• Repairing a replication subscriber – Gail Shaw (Blog|Twitter)
• Including Cluster Key in Non Clustered Index Definition – Russ Thomas(Blog|Twitter)

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• Troubleshooting Tempdb, a Case Study – Michael J. Swart (Blog|Twitter)
• What’s More Popular: SQL Server 2014, or SQL Server 2005? – Brent Ozar (Blog|Twitter)
• Yes, Foreign Keys Help Performance – Grant Fritchey (Blog|Twitter)
• How Many Objects Can Own Pages in a Mixed Extent – Robert L. Davis(Blog|Twitter)
• Filtered Indexes and IS NOT NULL – Kendra Little (Blog|Twitter)
• Prepping for learning Data Science – Buck Woody (Blog|Twitter)
• Performing Your Own SQL Server Triage – Brent Ozar (Blog|Twitter)
• Unusual errors with Distributed Replay – Gail Shaw (Blog|Twitter)

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• The Top 5 Mistakes DBAs Regret Later – Kendra Little (Blog|Twitter)
• Helping Your #Powershell With Twitter – Mike Fal (Blog|Twitter)
• Targeted Plan Cache Removal – Grant Fritchey (Blog|Twitter)
• Is leading an index with a BIT column always bad? – Erik Darling (Blog|Twitter)
• Live Query Statistics in SQL 2014, not just SQL 2016 – Rob Farley (Blog|Twitter)
• Pessimistic Concurrency in SQL Server – Klaus Aschenbrenner (Blog|Twitter)
• Why is This Partitioned Query Slower? – Kendra Little (Blog|Twitter)
• New Benchmark Feature in CPU-Z 1.73 – Glenn Berry (Blog|Twitter)
• Can DBCC PAGE access data in dropped tables? – Rob Farley (Blog|Twitter)
• Avoid Frequent use of TVPs With Wide Rows – Michael J. Swart (Blog|Twitter)
• Concurrency and Lock Granularity for OLTP Workloads – Chris Adkin (Blog|Twitter)
• In-Memory OLTP files – CSS SQL Server Engineers (Blog)

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• Using Azure VM SQL Automated Backup (and Restore) – Rob Sewell (Blog|Twitter)
• “I’d be a bad consultant if I didn’t put that in writing.” – Brent Ozar (Blog|Twitter)
• Cluster Shared Volume –  Finding Bottlenecks – FCNLB Team Blog (Blog)
• Downloading SFTP Files With SSIS – Tim Mitchell (Blog|Twitter)
• How to get up and running with Oracle and Linked Servers – CSS SQL Server Engineers (Blog)
• Getting the last good DBCC CHECKDB date – Erik Darling (Blog|Twitter)
• Processor Selection for SQL Server – Glenn Berry (Blog|Twitter)
• Differences Between Actual & Estimated Plans – Grant Fritchey (Blog|Twitter)
• Types of Performance Metrics – Michael J. Swart (Blog|Twitter)
• “Dear $firstname”: Tell Us Your Recruiter Stories – Doug Lane(Blog|Twitter)

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• Experience; There is no Substitute – Russ Thomas(Blog|Twitter)
• Checking Last Policy Based Management Execution – Mike Fal (Blog|Twitter)
• Stack Walking With Windows Performance Toolkit – Chris Adkin (Blog|Twitter)
• Windows Resource Monitor to Find Perf Bottlenecks – Glenn Berry (Blog|Twitter)
• But I Don’t Have a Test Server… – Grant Fritchey (Blog|Twitter)
• Updating All Jobs To Check For AG Primary Replica – Denny Cherry (Blog|Twitter)
• Conventional DBA Wisdom and High Performance Flash Storage – Chris Adkin (Blog|Twitter)
• SQL2014 Columnstore index rebuild and maintenance – Microsoft SQLCAT (Blog)
• How to pollute your Plan Cache with parameterized SQL – Klaus Aschenbrenner (Blog|Twitter)
• How Do You Know You’re Good At Your Job? – Grant Fritchey (Blog|Twitter)

Other Stuff Worth Reading

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• How to Create Indexed Views Online – Michael J. Swart (Blog|Twitter)
• The End of an Era – SQLFool scripts are now open-sourced – Michelle Ufford(Blog|Twier)
• How Do You Manage DBAs? Part 1: Measuring Backups – Brent Ozar (Blog|Twitter)
• #Powershell and SQL Server: SQLPS Challenges and Hurdles – Mike Fal (Blog|Twitter)
• Replication Won’t Refresh Your Dev Environments – Kendra Little (Blog|Twitter)
• SQL Server Diagnostic Information Queries for June 2015 – Glenn Berry (Blog|Twitter)
• New SQL Server Management Studio 2015 with Check for Updates! – Brent Ozar (Blog|Twitter)
• 101 Things I Wish I Knew About SQL Server – Thomas Larock (Blog|Twitter)
• Monitoring log activity with Extended Events – Paul Randal (Blog|Twitter)
• Why Zero Data Loss in SQL Server is Harder Than You Think – Kendra Little (Blog|Twitter)
• Identifying SQL 2014 Cardinality Estimator issues – CSS SQL Server Engineers (Blog)
• Should You Put Things in the master Database? – Brent Ozar (Blog|Twitter)
• Disaster recovery 101: fixing a broken boot page – Paul Randal (Blog|Twitter)
• DBAs and the Internet of Things – Rob Farley (Blog|Twitter)

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• The Right Tool For the Job: XPERF Flags and Diagnosing IO Issues – Chris Adkin (Blog|Twitter)
• How to Set Up AlwaysOn Availability Groups in SQL Server 2016 – Brent Ozar (Blog|Twitter)
• The Cult of Automation – Mike Fal (Blog|Twitter)
• Features SQL Server Needs to Add (And Drop) – Brent Ozar (Blog|Twitter)
• Parallelism and Columnstore Indexes – Grant Fritchey (Blog|Twitter)
• 42 Things You Should Never, Ever Say to a DBA – Thomas Larock (Blog|Twitter)
• Finding a transaction in the log for a particular user – Paul Randal (Blog|Twitter)
• Contest: Write the Scariest DBA Sentence (10 words or less) – Kendra Little (Blog|Twitter)
• It’s Hard To Destroy Data – Michael J. Swart (Blog|Twitter)
• Configuring a Multi-Subnet SQL Server Test Environment – Jonathan Kehayias (Blog|Twitter)
• Database Engine Tuning Advisor – Grant Fritchey (Blog|Twitter)
• How to Troubleshoot SQL Server Connection Timeouts – Brent Ozar (Blog|Twitter)
• Behaviour change for delete … output … into in SQL Server 2014 – Matt Bowler (Blog)

SQL Community Conversations

These are some of hot topics being discussed right now in the Forum by ambitious Data Professionals just like you. Join the conversation.

• What have you learned this week?
• Is 56 too old to chase a career in SQL Server?

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• How would indexes on AG readable secondaries work? – Paul Randal (Blog|Twitter)
• Is Performance Better With LEFT JOIN or RIGHT JOIN? – Grant Fritchey (Blog|Twitter)
• Inconsistent analysis in read committed using locking – Kimberly Tripp (Blog|Twitter)
• Exploring #Powershell – Mike Fal (Blog|Twitter)
• Finches and Job Roles – Jeremiah Peschka (Blog|Twitter)
• How to Fake Load Tests with SQLQueryStress – Brent Ozar (Blog|Twitter)
• Effects of Persisted Columns on Performance – Grant Fritchey (Blog|Twitter)
• Who’s In Your Fixed Server Roles? – Bob Pusateri (Blog|Twitter)
• Databases Need a Kosher Certification – Brent Ozar (Blog|Twitter)
• Survey: page life expectancy – Paul Randal (Blog|Twitter)

If you have an article or blog post suggestion, a question about SQL Server or just fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• Well Known and Not So Well Known SQL Tuning “Knobs and switches” – Chris Adkin (Blog|Twitter)
• When DBCC DROPCLEANBUFFERS doesn’t work – Paul Randal (Blog|Twitter)
• Basic VMware and Hyper-V Terminology for the SQL Server DBA – Kendra Little (Blog|Twitter)
• Availability Groups, Agent Jobs, and #Powershell – Mike Fal (Blog|Twitter)
• Query Hash Formula Changes Between Versions – Grant Fritchey (Blog|Twitter)
• Point in Time Recovery for Memory—Optimized Tables – Kalen Delaney (Blog|Twitter)
• Are Index ‘Included’ Columns in Your Multi-Column Statistics? – Kendra Little (Blog|Twitter)
• Error Creating Remote Distro When Creating a Local Distro – Robert L. Davis(Blog|Twitter)
• Compressing LOB (XML) Data in the Database – Dmitri Korotkevitch (Blog)
• Forced parameterization to the rescue – CSS SQL Server Engineers (Blog)
• SQL Server, Hyper-Threading and OLTP Workloads – Chris Adkin (Blog|Twitter)
• Should You Be a SQL Server DBA? (video) – Kendra Little (Blog|Twitter)

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

From the SQL Server blogs

• “Breaking” News: Don’t Install SQL Server 2014 SP1 – Brent Ozar (Blog|Twitter)
• REPLICATION preventing log reuse but no replication configured – Paul Randal (Blog|Twitter)
• Effectively Using Invoke-SqlCmd – Mike Fal (Blog|Twitter)
• Re-Inventing the Recursive CTE – Adam Machanic (Blog|Twitter)
• Look at Blocking By Index – Michael J. Swart (Blog|Twitter)
• SHOWPLAN permission denied even if the database isn’t actually used – Rob Farley (Blog|Twitter)
• sp_whoisactive and Azure SQL Database – Adam Machanic (Blog|Twitter)
• Stored Proc Execution with Parameters, Variables, & Literals – Kimberly Tripp (Blog|Twitter)
• Finding Scalar Aggregate Indexed Views in Your Database – Michael J. Swart (Blog|Twitter)
• When is a Hyper-V Virtual Machine Not Really a Virtual Machine? – Kendra Little (Blog|Twitter)

Other Stuff Worth Reading

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend!

From the SQL Server blogs

• Incomplete checkpoints and recovery – Paul Randal (Blog|Twitter)
• Simple Parameterization and Data Types – Grant Fritchey (Blog|Twitter)
• Getting BLOBS out of the Database – Jeremiah Peschka (Blog|Twitter)
• How to Become an Expert at Anything in SQL Server – Kendra Little (Blog|Twitter)
• Why You Shouldn’t Upgrade SQL Server – Brent Ozar (Blog|Twitter)
• Upgrading to SQL Server 2014: Frequently Asked Questions – Kendra Little (Blog|Twitter)
• Auditing SQL Execution Times With #Powershell – Mike Fal (Blog|Twitter)
• How To: Find When SQL Server Wait Stats Were Last Cleared – Thomas Larock (Blog|Twitter)
• Diagnosing Spinlock Problems By Doing The Math – Chris Adkin (Blog|Twitter)
• Does statistics update cause a recompile? – CSS SQL Server Engineers (Blog)
• The maths most SAN engineers do not understand in context of Database Servers – Tony Rogerson (Blog|Twitter)

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart.