TIL: Microsoft Azure Part 1
I thought maybe it would be a good idea to start a multi-part series on Today I Learned (TIL) about...
2017-05-17
532 reads
SQL Server on Docker with new Environment Variables
As of CTP 2.1 for SQL Server 2017 a set of new environment variables are available. These variables allow us...
2017-05-17
3,454 reads
Employers, let your people work from home
Work from home is, astoundingly, still not the norm in United States IT offices. This is ludicrous, because employees want...
2017-05-17
444 reads
Querying a Database
When we want to retrieve information from a database, we query the structure with language appropriate to the database. Remember...
2017-05-17
108 reads
Weaning yourself off of SQL Profiler (Part 2)
In a prior post, I shared a script that will take a running trace and show you the XE events...
2017-05-17
575 reads
SQL Server 2016 SP1 – A significant change to licencing
A lot has been written about the change of licencing in SQL 2016 SP1. Here's my two-pence worth.
2017-05-17
17 reads
SQL Data Warehouse reference architectures
With so many product options to choose from for building a big data solution in the cloud, such as SQL...
2017-05-17
808 reads
Power BI Custom Visuals Class (Module 51 – Hierarchy Slicer)
In this module you will learn how to use the Hierarchy Slicer Power BI Custom Visual. The Hierarchy Slicer visual...
2017-05-30 (first published: 2017-05-17)
1,404 reads
T-SQL FizzBuzz
I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old...
2017-05-17
2,870 reads
Update to DBCC LOGINFO in SQL Server 2017
One of the new features included in SQL Server 2017 that Microsoft has detailed here is a new DMF called...
2017-05-17
1,247 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