SQL 101 Learn SQL. Not too much. Mostly online.
I’ve had people ask me how to learn SQL without installing a database. This past Sunday afternoon I saw a packed class of current and aspiring data scientists learn SQL in a great class taught by Ted Petrou . You can indeed learn SQL for free wit …
SQL Server 2017: Potentially Interesting New Extended Events
You still won’t use them And I predict that Extended Events will remain as niche-only use for specific troubleshooting scenarios. Very few monitoring tools use them, and the ones that do still rely on traces and DMV queries for the bulk of their …
Extending DevOps practices to SQL Server databases with Redgate, Git & Jenkins
Join Microsoft Data Platform MVP, Grant Fritchey, for our next Database DevOps demo webinar. He’ll be plugging Redgate’s tools into Git and Jenkins to show you how Redgate’s Database DevOps solution helps you build, test and deploy your dat …
Azure DWH part 14: PolyBase to access to non structured data
In this article, we will learn how to work with PolyBase using Azure SQL DWH.
SQL Server Management Studio – New Feature – Object Explorer Query Tracking
A few days ago, I wrote a blog about a new feature in SSMS and I got few emails asking me to share such quick and fresh information. You can read my earlier blog here SQL Download – SQL Server Management Studio (SSMS) – Performance Das …
Upgrading SQL Server–Replacing Slow Hardware Part 2
Previously, we talked about the single-threaded performance, CPU capacity and hardware cost difference between an extremely poor server model and processor SKU choice and a much better server model and processor SKU choice from about three and a half y …
How to Allow Only Alphabets in Column? – Interview Question of the Week #136
Question: How to Allow Only Alphabets in Column? Answer: This was a real world scenario and I have mixed feeling about this kind of question being asked in interviews. However, let us accept this question as it is and let us see how to solve this …
Upgrading SQL Server–Replacing Slow Hardware
One unfortunately common scenario is a situation where someone made a very poor processor choice sometime in the past for a database server that runs a mission critical workload. When I do health checks for SQLskills, I encounter both good processor ch …
SQL SERVER – 3 Different Usage of DBCC SQLPERF
Have you ever wondered what does DBCC SQLPERF do in SQL Server? Well, I have often thought about it and here is the most simple answer for the same. Method 1: Displays the LogSpace This method displays the current size of the transaction log and t …
Tech Outbound SQL Cruise 2017 Mid-Week Update
Midweek Update on SQL Cruise Alaska 2017 read more
Upgrading SQL Server–Compelling Upgrade Arguments
Over the course of my career, I can’t remember too many people coming to me and initiating the conversation about upgrading to a new version of SQL Server, a new version of Windows Server or a new set of server hardware and storage. As a DBA, Dat …
Using the Copy Wizard for the Azure Data Factory
The series so far: Creating a Custom .NET Activity Pipeline for Azure Data Factory Using the Copy Wizard for the Azure Data Factory Azure Data Factory is the integration tool in Azure which allows us to move data around in preparation for its storage a …
What If Week: What Would You Add?
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 …
SQL SERVER – Cluster Patching: The RPC Server is Too Busy to Complete This Operation
If you have ever contacted me via email, you would know that I am very active in replying to emails. Many of the emails are for suggestions and I don’t get much time to help everyone, but I do reply to them letting them know the alternatives. If …
Upgrading SQL Server–Day 17
As I discussed yesterday, it is sometimes possible to experience performance regressions after upgrading to a new version of SQL Server, even when it is running on a new, presumably faster database server. This is much less likely to happen if you have …