SQL Server 2014: protection against Database Administrator
Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly....
2015-09-10
1,639 reads
SQL Server 2014: protection against Database Administrator
Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly. The questions like “How can I protect my data...
2015-09-10
10 reads
SQL Server 2014: protection against Database Administrator
Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly. The questions like “How can I protect my data...
2015-09-10
17 reads
SQL Server 2014 Buffer Pool Extension part 3: system monitoring
In this article I’d like to tell about monitoring tools available in SQL Server 2014 to evaluate the performance of...
2015-09-03
1,293 reads
Monitoring of free space in database files
Monitoring of the size of database files is one of the important DBA tasks and this process should be automated....
2015-09-02
649 reads
CONTEXT_INFO and efficient mass update on a large table with a trigger
Let`s assume we have following task – make changes to the data in a large table that has consistency checker in...
2015-09-01
750 reads
Buffer Pool Extension in SQL Server 2014 part 2: benchmark testing
Let’s take a closer look at how we can speed up the system’s performance using the Buffer Pool Extension. For...
2015-08-31
2,028 reads
Buffer Pool Extension in SQL Server 2014
I guess many have heard the phrase «640K ought to be enough for anybody», which Bill Gates is mistakenly thought...
2015-08-17
1,746 reads
Data corruption in SQL Server 2012 and 2014 when rebuilding indexes online
When I hear the discussion about causes of data corruption in SQL Server, I always mention bugs in the operating...
2015-08-17
2,001 reads
Step by Step Guide to SQL Server AlwaysOn
AlwaysOn technology in MS SQL Server is designed to increase the availability of your database, it is another step toward...
2015-08-12 (first published: 2015-08-06)
16,883 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers