Setting SQL Server Max Memory Dangerously Low
Hopefully you know the relevance and importance of setting a correct value for max memory on your SQL Server. By...
2017-05-18
431 reads
Database snapshot could not be created and the database or table could not be locked
DBCC CheckDB failed with error “database snapshot could not be created and the database or table could not be locked”
Error:...
2017-05-18
3,909 reads
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,455 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
809 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
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