Azure SQL Database – Implementing Azure AD Authentication
Marcin Policht focuses on the specifics of using Azure Active Directory to authenticate to Azure SQL Database.
SQL SERVER – Unable to bring resource online. Error – Data source name not found and no default driver specified
One of my blog readers reported a strange issue to me. As per the issue described, they were unable to bring SQL Server resource in cluster online, only on one node of the cluster. I always use for error messages, but they said that SQL resource goes t …
Don’t Expect Good Decisions from Bad Data
Bad Data Bad Decisions read more
Can Indexes My Query Doesn’t Use Help My Query?
This came up during Office Hours And I love questions like this, because they reveal some interesting underpinnings of how the cardinality estimator works. It was something along the lines of “I have a slow query, and when I add an index the quer …
Find and Remove Duplicate Rows from a SQL Server Table
Though duplicate rows are bad practice, sometimes they’re necessary for a short time. But how do you clean your tables when they’re no longer needed? Sergey Gigoyan provides a few different solutions.
Stairway to Biml Level 6 – Programming with Metadata
In this next level of the Stairway to Biml, learn how metadata makes your Biml code more efficient and helpful in generating packages.
Cloud Consulting Pre-Engagement Questionnaire – A Bookmark
The cloud phenomenon is no more a dream for many, but a reality for several customers I have been working with. Many of my customers are looking for guidance and from time to time I get an opportunity to have some deep constructive discussions. These d …
FLAS
The information technology field is full of obfuscation. There are many three letter acronyms, including the meta three letter acronym TLA. Now in the era of Big Data and Cloud, we have four letter acronyms, what I call FLAS, two of which are ACID and …
Announcing our Black Friday 2016 Sales!
Every year on Black Friday (the first Friday after Thanksgiving), we have a little fun here and celebrate the same way other stores do. Here’s the sales we’re running this year: 5 $1 seats will be available in each of our 4-day online …
Using OVER() to Remove Duplicate Rows
Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony D …
How I prepare for a presentation
Some people say I talk a lot – but I guess it depends on the context. Certainly, for many years, I’ve been fairly comfortable about standing up in front of people and explaining things. Whether it’s teaching a course, leading a worksh …
SQL SERVER – Added New Node in Windows Cluster and AlwaysOn Availability Databases Stopped Working
Almost all the time, whenever there is a wizard, it’s a human habit to go with the defaults and finally click finish. Once of my client sent below email to me. In this blog post we are going to learn about Added New Node in Windows Cluster a …
SQL Server Diagnostic Information Queries for November 2016
This month, I have added several new queries to SQL Server 2016 set, along with adding additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets. I have gotten quite a bit of interest about making a special version of these queri …
[Video] Office Hours 2016/11/02 (With Transcriptions)
This week, Brent, Richie, Tara, and Erik discuss vendor licensing, rebuilding indexes, analysis services, using trace flag 174, and the team’s PASS Summit impressions and highlights. Here’s the video on YouTube: You can register to attend …
SSC 2016 User Survey and Competition
What do you want to see more of on SQL Server Central? Anything you think we should get rid of? Let us know in this 17-question user survey, and at the end you can choose to be entered into a draw to win a $100 Amazon gift card. Thanks to everyone who’ …