[Video] Office Hours 2018/9/19 (With Transcriptions)
This week, Brent, Tara, Erik, and Richie discuss moving views between databases, Cluster Quorum File Share on AlwaysOn, checking for corruption, rebooting/restarting SQL server after applying cumulative updates, how many drive letter to use for a VM, d …
How to Escape a Single Quote in SQL Server? – Interview Question of the Week #192
Question: How to Escape a Single Quote in SQL Server? Answer: Yesterday, I had an opportunity to visit a SQL User Group in Bangalore, India, and during the event, I had received a very simple question from a college student. As soon as he asked th …
Leaked: SQL Server 2019 Big Data Clusters Introduction Video
Psst – you’re probably not supposed to see this yet, but look what @WalkingCat found: SQL Server 2019 Vision pic.twitter.com/zbjI28FYSu — WalkingCat (@h0x0d) September 21, 2018 What the video says Growing volumes of data create deep p …
SQL SERVER – Query to Find the Longest Running Function – Function Elapsed Time
I love my job of SQL Server Performance Tuning and Optimization consultant as every single day I walk into the customer door (well, to be honest, it is actually virtual door of GoToMeeting), I face new challenges and learn new ways to tune SQL Server. …
6 DBA Lessons I Wish Someone Would Have Taught Me Earlier
I was talking to a DBA friend of mine, reminiscing about some of the hard lessons we learned early on in our career. The more we talked, the more we realized that there should probably be a one-page cheat-sheet that you’re required to read before …
Adding User Comments to Reports in SQL Server Reporting Services
In this tip we look at a new feature in SQL Server Reporting Services that allows users to leave comments about reports.
Learning R in SQL Server
Learn about the new R Services in SQL Server 2016
SQL SERVER – Restoring SQL Server 2017 to SQL Server 2005 Using Generate Scripts
Let me answer the first question first – There is no way to backup and restore SQL Server 2017 to SQL Server 2005 with the help of any tools. In this blog post, we will learn about how we can generate scripts to achieve this task. However, there …
Finding & Fixing Statistics Without Histograms
Men Without Hats – now those guys were cool: Statistics Without Histograms – not so much. If you have a database that’s been passed along from one SQL Server to another, gradually upgraded over the years, or if you’ve had a tabl …
New VLF status value
At least since I started working on the SQL Server team (just after 7.0 shipped) and since then there have only been two VLF status codes: 0 = the VLF is not active (i.e. it can be (re)activated and overwritten) (1 = not used and no-one seems to rememb …
Advanced Testing of Your PowerShell Code with Pester
Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to use the testing tool, Pester, to perform unit, integration, and acceptance testing.
Identifying the right Service tier for Azure Database
Determining the number of DTUs which will help in deciding the service tier for Azure SQL.
Pseudonymizing a Database with Realistic Data for Development Work
In this article Phil Factor shows us how to surgically alter data from an entire database that can identify individuals but leave everything else intact.
Encryption Key Management for Microsoft SQL Server 2008-2016
Organizations continue to experience damaging losses due to data breaches, including legal costs, costs to reimburse customer and employees, lost stakeholder value, and reduction of goodwill. In recognizing the importance of proper key management for
SQL SERVER – Simple Method to Find FIRST and LAST Day of Current Date
In my very old post SQL SERVER – Query to Find First and Last Day of Current Month – Date Function, I had explained how to find the first day and last day of the current date. The method I showed you in the old posted uses CONVERT function …