Latest Blog Posts
TIMESTAMP vs. DATETIME: What’s the diff? The TIMESTAMP data type in SQL...
The post SQL Server’s TIMESTAMP Is Not What You May Think It Is. appeared first on WaterOx Consulting.
I was doing a database code deployment the other night and the first step in the release plan was “Take a full database backup in case we have to roll back the deployment”. The database in question was about 100 GB in size, so not huge, but not small either.… Read more
As I’ve mentioned before, living in Louisville offers up great opportunities to various events within the SQL Community. This weekend I’ll be traveling down to Spartanburg, South Carolina to speak at SQL Saturday #431. I am always honored to be chosen to speak and this time isn’t any different. While… Read more
I have mentioned predicate order previously and wanted to make sure I drive home the importance of the predicate order when dealing with Extended Events. This is an important topic because it can be very helpful in maintaining a reasonably performing event monitoring system.
The proper order of a predicate… Read more
I’ve you’ve run a query similar to the following:
SELECT * FROM sys.dm_exec_requests CROSS APPLY sys.dm_exec_sql_text(sql_handle);
And gotten an error similar to:
Msg 321, Level 15, State 1, Line 9
“sql_handle” is not a recognized table hints option. If it is intended as a parameter to a table-valued function or… Read more
The next version of SSIS is on the horizon. Are you ready?
In next Tuesday’s webinar, I’ll be reviewing and demonstrating the new features of SQL Server Integration Services. Microsoft recently released the CTP bits for SQL Server and SQL Server Data Tools, both of which show several useful… Read more
I am going to ignore the fact that people don't want to install visual studio on a build server, in the future there will likely be a way to install just the required components rather than everything. Today, the way I see it is that I develop in Visual Studio,…
tl,dr; We’re raising money for Doctors without Borders. Donate and a few of us will dress up at the Summit. You don’t have to attend the Summit to have some fun here.
Last year a bunch of us agreed to get silly to raise money. We ended up getting over… Read more
It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes corrupt, is running CheckDB with repair allow data loss safe?
The theory is, since the subscriber is a copy of another database, allowing CheckDB to discard data in the process… Read more
You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the company would send you to PASS Summit 2015. A few days or weeks elapse and you get word that you were the chosen one from the company to attend… Read more
In the previous installment, I began covering the topic of predicates. In that article I demonstrated that there are multiple types of predicates. There are two objects that fall into the predicate category and then there are data comparison predicates (those that are not objects).
The two objects are pred_compare… Read more
Let’s say you have a table that records transactions along with the date of when the transaction took place. Wait, I’m being told that Production.TransactionHistory in AdventureWorks sample database matches this description. So let’s use that for this demonstration.
Here’s the simplified schema of that table.
CREATE TABLE [Production].[TransactionHistory] (…
There has been some really useful blogs and articles posted over the last week or so, this is my top 5 in no particular order
- Interesting post here from BrentOzar.com looking at the statistics on the uptake of SQL Server 2014 and the reluctance of businesses to move from older…
Encrypting Connections To SQL Server Using Certificates
In this post we’re going to cover configuring a connection string in .NET applications for encrypting connections to SQL Server using certificates. The audience for this document is a developer that needs to configure encrypted connections from applications to a database server.
Encrypting… Read more
Following my post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database.
In this post I will show how to create the following report
Although you will find so many items of data… Read more
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects (tables or indexes).
First let me remind you that some versions of SQL Server (Enterprise, Evaluation, Developer) allow you to perform… Read more
In the last post (here), we have highlighted a number of ways to setup disaster recovery in SQL server, we will discuss the first one here - Log Shipping.
Log shipping (LS for short) has been around for many years - since…
Statistics, in simplest terms, refer to the distribution of data in a column or index. They are represented in a form of a histogram with at the most 200 steps, regardless of the number of rows in the column or index. A lot about statistics can be found in this… Read more