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
6 reads
Forrards Group Database Blog
SQL Server 2014: parallel execution of SELECT INTO statements
In Microsoft SQL Server 2014 new in-memory options are presented. One of them is online transaction processing (OLTP) that complementing...
2015-09-18 (first published: 2015-09-09)
3,266 reads
Buffer Pool Extension in SQL Server 2014 part 4: benchmark testing for update operations
One of my previous articles was devoted to carrying out a range of tests to compare speed of data read...
2015-09-10 (first published: 2015-09-04)
1,820 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,284 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
629 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
736 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,000 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
1,988 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,735 reads
System databases maintenance in SQL Server
Let’s talk about maintenance of system databases in MS SQL Server. There are a few differences from user databases.
At first let`s remember...
2015-08-12
2,009 reads
Blogs
SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!
They run, they return data. So what? Some SQL queries just waste your time...
Copilot Outside of SSMS Seems to Work
By Steve Jones
I read Brent’s first look at SSMS and Copilot in there. He didn’t have...
A New Word: Falesia
By Steve Jones
falesia– n. the disquieting awareness that someone’s importance to you and your importance to...
Forums
What tool or tools do people like for monitoring SQL servers?
I have a few tools at my disposal but none of them seems like...
average duration increasing inline with exec counts
As the title says , I've got a handful of stored procs where the...
Question of the Day
A Basic Data API Builder ADD
What parameters are required for the dab add command in the Data API Builder?
See possible answers