Database Configuration
It’s amazing just how much the landscape changed with the release of SQL Server 2016 SP1. For example, I just...
2016-12-20
465 reads
Blog Posts
Last Restore of a Database – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-20
672 reads
Last Restore of a Database – Back to Basics
In this article I explore the basics around how to determine when a database was last restored.
Related Posts:
Changing Default Logs Directory - Back to Basics January 4, 2018
SQL...
2016-12-20
45 reads
On Being Disruptive
Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just...
2016-12-20 (first published: 2016-12-05)
1,733 reads
Report Portal in SSRS 2016
SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction...
2016-12-20
574 reads
SQL Server 2016 has reduced the NoSQL JSON “advantage” over SQL Server
Microsoft has finally implement support for JSON data in SQL Server 2016 and in Azure SQL Database. In a previous...
2016-12-20
3,641 reads
SQL Server and Hyper-threading
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation...
2016-12-20
6,029 reads
SQL Server and Hyper-threading
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation...
2016-12-20
279 reads
SQL Server and Hyper-threading
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation for them. Licensing is given at the end of...
2016-12-20
34 reads
SQL Server and Hyper-threading
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation for them. Licensing is given at the end of...
2016-12-20
19 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