Latest Blog Posts
People ask me all the time how to become a DBA. This is a topic that so many colleagues of mine write about, and talk about in their professional development tracks. The more important question is once you “are” in the role of DBA, what to do next? Read more
It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in comparison with Standard Edition. One of these improvements is Advanced Scanning, which allows multiple scans to share one physical read from… Read more
AlwaysOn Availability Groups is a great technology that centralizes the management of High Availability, Disaster Recovery and Scale-Out. However, in many cases, the good old Database Mirroring is just good enough (and in some cases, better):
Database Mirroring can work in Standard Edition
Database Mirroring is supported in both… Read more
Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as it can ease some of the escaping of strings.
However, I normally use it for table/column names, and so hadn’t ran into a “gotcha” of this function until today. Read more
To help with this scenario (it is pretty specific):
You have a table that has columns that you do not know about when you create the dacpac, possibly you have a customer who modifies your schema after you deploy. If you deploy your dacpac those columns will be dropped which…
Just over a week ago I announced that SQL Solutions Group was getting ready to host a day of training, FREECON if you will, in Seattle as a prelude to the PASS Summit of 2015. You can read all about that here, with registration being here.
While I… Read more
In my deployment filter I have been asked a couple of times to allow columns that exist on a table that do not exist in a dacpac to be ignored so that they are deleted. The typical scenario is that a vendor supplies a database and then customers can add…
Counter offers (and the related discussions) are an emotional topic. The comments on two of my editorials for SQLServerCentral (The Counter Offer – Part 1 and The Counter Offer – Part 2) show that. The takeaway for me is that we are still torn about being loyal employees… Read more
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