SQLskills SQL101: Readable secondary performance problems
As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologi …
What If Week: What Would You Look At First?
For this week’s What If series, we’re exploring what would happen if you had access to SQL Server’s source code – like if you got a job at Microsoft, signed a partner NDA, if the code leaked, or if it went open source. Today …
Working with SQL Server for Linux Cross-Platform
Next week, on August 24th a new webinar from the PASS Application Development Virtual Group will be aired. This time the topic is the Cross-Platform support introduced with the forthcoming SQL Server 2017. Maximo Trinidad will delivery the following se …
Monitoring Azure Cloud and Hybrid Environments
Cloud-based services and applications must still be monitored just like the on-premise ones. You still need most of your data center activities that ensure that your planning, budgeting, security and service-level obligations are met wherever the data …
New permissions features brings access control to SQL Clone
SQL Clone permissions has been high on the wish-list for users and the new feature addresses it in an intuitive way that enables you to allocate and change permissions quickly and easily.
Stairway to SQL Server Automated Database Testing Level 1: Why You Need TDD
The first article in this Stairway Series makes the case for test-driven development.
SQL Server – Configuration Manager Console Running Very Slow and Time Out
SQL Server Performance Tuning is my hobby, passion and a job. During my recent consulting engagement for Comprehensive Database Performance Health Check, I had to face a very interesting situation which I had never faced before. I personally take any c …
Upgrading SQL Server–Day 15
One of the interesting new features that was added in SQL Server 2014 was delayed durability. This feature lets you trade some transaction durability for increased log write performance. This is possible because delayed durable transaction commits are …
SQLskills SQL101: Log shipping performance problems
As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologi …
What If Week: SQL Server Code Review
Top Secret For the sake of any lawyers out there reading, I want to start by saying we do not now, nor have we ever possessed SQL Server’s source code. I wouldn’t even know what to do with it if I did — I doubt it’s written in c …
Local Books Online, as of 2017 August
This seems to be a never ending story, having a locally installed Books Online for SQL Server, that is. Some of you recall that I have posted about this before. This post is about my experiences for the current state of Books Online. Things has changed …
Using Database Master Keys in SQL Server
Learn the basics of Database Master Keys and how you can use them in SQL Server.
SQL SERVER – Database Files Initial Size Changing Automatically
One of my clients reported an interesting issue and I was needed to wear detective cap to solve it. The mystery, for which they hired me was as below for Database Files Initial Size Changing Automatically. Pinal, We see an interesting issue, and w …
So why do you want to come to our training? And the winners are…
Wow! We had 22 entries for our competition (writing a post is a high bar so I was expecting 20-30) to win a free seat in either our IEPTO1 or IEPTO2 training classes in Chicago in October. That was a lot of reading to get through to pick the winne …
Upgrading SQL Server–Day 14
One upgrade opportunity that you can take advantage of pretty easily, whether or not you are actually upgrading your actual database servers, is to use a modern version of SQL Server Management Studio (SSMS). Starting with SQL Server 2016, SSMS was sep …