This Week in Data – Episode 15 (Why People Are Flocking to SQL Server)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-12-07
839 reads
Blog Posts
VMware vSphere 6.5 breaks your SQL Server vNUMA settings
VMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine,...
2016-12-07 (first published: 2016-11-29)
3,359 reads
A Python SQL Server App
I got a link recently from Microsoft on building apps easily for SQL Server. At the top of the page,...
2016-12-06
1,396 reads
Checking your Wait Stats via Power BI
Wait stats is my go to thing, however I do get bored just querying it via a table so I...
2016-12-06
807 reads
In Memory OLTP – 1
In-Memory OLTP (A.K.A. Hekaton) is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated into SQL...
2016-12-06
659 reads
Power BI Custom Visuals Class (Module 27 – Synoptic Panel)
In this module you will learn how to use the Synoptic Panel Power BI Custom Visual. The Synoptic Panel is...
2016-12-06 (first published: 2016-11-29)
2,111 reads
Power BI Custom Visuals Class (Module 28 – Sankey)
In this module you will learn how to use the Sankey Power BI Custom Visual. The Sankey is a type...
2016-12-06
972 reads
sp_WhatsupQueryStore version 1.1 released
Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are...
2016-12-06
472 reads
Total Cost of Ownership (TCO) Calculator
For a long time clients would ask me how to determine the cost savings by migrating their applications and databases...
2016-12-06
1,266 reads
TSQL Tuesday #85 Invite – Backup and Recovery
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...
2016-12-06
554 reads
Blogs
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...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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