Blue Screen Your SQL Server On-Demand
These days I do a lot of testing with SQL Server. When I am testing new features or helping clients implement SQL Server High Availability solutions I want to...
2017-03-10
47 reads
Blue Screen Your SQL Server On-Demand
These days I do a lot of testing with SQL Server. When I am testing new features or helping clients...
2017-03-10
659 reads
Working with SQLSaturday SpeedPASSes
SQLSaturday SpeedPASSes
I’ve been working with running SQLSaturdays in the Richmond, VA area for several years now. It seems that every...
2017-03-09
459 reads
Power BI and Excel options for Hadoop
Below I have attempted to list the various options for reporting off of Hadoop (HDInsight, HDP, Cloudera) using Power BI...
2017-03-09
576 reads
Embrace The Missing Index DMVs - But Proceed with Caution!
One of the performance tools I use all of the time is the set of Missing Index DMVs: · sys.dm_db_missing_index_details– Detailed...
2017-03-22 (first published: 2017-03-09)
4,143 reads
Metadata Hygiene
Those who follow my blog know that I write a lot about data quality. Measuring and improving the quality of...
2017-03-09
421 reads
Create a DACPAC to Move Databases–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-08
948 reads
Identifying a row’s physical location
While you may not need to worry about the physical location of a row very often, every so often the...
2017-03-08
517 reads
Review of Azure Fundamentals class on Openedx
My company has recently adopted a Cloud first attitude. Now that’s different from Microsoft’s Cloud first. Microsoft is putting new...
2017-03-08
515 reads
SQL Browser, what is it good for? Absolutely something!
Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some...
2017-03-08
444 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers