PASS Summit 2018 Keynote Day 2: Live Blog
Today is the second day of the 2018 PASS Summit, the largest annual gathering of Microsoft data professionals. Yesterday, we got the marketing keynote that caught attendees up with the current state of SQL Server 2019 and Azure services. The atten …
T-SQL Decommenter Part I
Introduction to a T-SQL query that remove comments from T-SQL code
Help Redgate improve Data Masker for SQL Server?
Redgate are looking for people to help them get a deep understanding of compliance and SQL Server data masking requirements in order to ensure they can provide a world class solution. In return for your feedback you’ll have early access to new re …
Azure EA Financial Reporting and Granular Access to Data Through the Enterprise
With the billing data from your Azure Enterprise Agreement collected into one database, it is still necessary to break down the costs and provide access to the correct departments and individuals. This is important for chargeback and further analysis. …
SQL SERVER – AlwaysOn – Queries Waiting for HADR_AR_CRITICAL_SECTION_ENTRY
In the past few days, I am being contacted by clients for AlwaysOn related issue. I have been writing a blog about them. In this blog, we would learn about how to fix wait for HADR_AR_CRITICAL_SECTION_ENTRY. THE SITUATION My client was using SQL Server …
PASS Summit 2018 Keynote Day 1: Live Blog
Today is the opening day of the 2018 PASS Summit, the largest annual gathering of Microsoft data professionals. Every year, thousands of us gather at the Seattle Convention Center to connect, learn, and share. On this first day of the conference, all t …
What’s New in SQL Server 2019 CTP 2.1: Faster Functions
A while back, we talked you through a public whitepaper about how Microsoft was working on making user-defined functions go faster. Now that the next preview (CTP2.1) of SQL Server 2019 is out, you can start getting your hands on Froid, the performance …
Simple way to Import XML Data into SQL Server with T-SQL
In this tip we look at a simple way to import a simple XML document into a SQL Server table. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the r …
SQL SERVER – Cluster Resource ‘AGName’ of type ‘SQL Server Availability Group’ in Clustered Role ‘AGName’ Failed
I never leave my customers alone when they are having an issue with something which I helped them. Typically, I help customers in creating POC and deploying AlwaysOn Availability Groups. Just the other day while doing the Comprehensive Database Pe …
Caution about Restoring via SSMS v17
A default value has changed in the SSMS v7 restore wizard, and the consequences can be severe.
SQL Clone V3: New features heighten visibility and manageability of clones and images.
With a brand new dashboard, activity feed and search functionality there is a lot happening in the SQL Clone v3 release. Check out the full breakdown of the update and get onto the latest version.
How Big is Your Transaction Log?
If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction …
SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step msdb110_upgrade.sql encountered error 926, state 1, severity 25
I have helped many clients in upgrade failures via my On-Demand consulting and I am amazed to see various ways which can break SQL Server upgrade. In this blog we would learn about fixing error Script level upgrade for database ‘master’ fai …
Picking #PASSsummit Sessions to Attend
So you’re going to the PASS Summit in Seattle this week, and you’re overwhelmed with the number of session choices. You’re not alone – it overwhelms me too. There are some slots where I wish I could clone myself and attend sever …
SQL Prompt as a Layout Tool: A Survival Guide
Phil Factor’s guide to taming SQL Prompt layout options, and getting it to format code just the way you like it.