Connect SQL Server on Linux using Bash on Ubuntu on Windows
Since Microsoft has launched SQL Server on Linux, you would be working on both the platforms Linux and Windows. You...
2017-07-21
17,137 reads
SSMS Tip #2: Shortcut Keys for SQLCMD Mode, Open Containing Folder, Copy Full Path, etc
In SQL Server Management Studio (SSMS), there are a lot of options and functions. In fact, there are so many...
2017-07-20
2,204 reads
Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing
I recently got a new laptop and had to go through the ritual of reinstalling all my programs and drivers....
2017-07-20
10,027 reads
Lots of Resources
I’ve got a small Azure subscription, but there are a lot of resources in my mini lab. Forty seven, to...
2017-07-20
500 reads
Azure SQL Data Sync 2.0
Azure SQL Data Sync has been ignored for quite some time, but has finally gotten an update (it’s in public...
2017-07-20
594 reads
Back to the Big Easy and SQL Saturday #628 in Baton Rouge
I’ve been fortunate enough to get to the Baton Rouge SQL Saturday a number of times. I think I’ve been...
2017-07-20
403 reads
Remember What It’s Like to Be a Rookie
File this under “soft skills.” Let me start with a recent experience.
Last week I was leading a team of youth...
2017-08-08 (first published: 2017-07-20)
1,696 reads
Azure Cloud “Fear” Busting #2 – Seeking for Better Performance
We all want high performing applications and when you are in the cloud that is no different, if anything it...
2017-08-07 (first published: 2017-07-20)
1,380 reads
How to Use SQL Temporal Tables For Easy Point-In-Time Analysis
Watch this week's video on YouTube
Have you ever needed to look at what data in a table used to look like?
If you have, it probably took a knuckle-cracking filled...
2017-07-20
16 reads
Speaking at PASS Summit 2017
I’m very pleased to announce that I will be speaking at PASS Summit 2017! This is my first time speaking at PASS Summit and I’m very excited to be...
2017-07-19
5 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