2014-09-25 (first published: 2010-12-23)
25,703 reads
2014-09-25 (first published: 2010-12-23)
25,703 reads
Lately I spent some time evaluating some monitoring tools for SQL Server and one thing that struck me very negatively...
2014-09-05
456 reads
I haven’t been blogging much lately, actually I haven’t been blogging at all in the last 4 months. The reason...
2014-07-22
619 reads
Yesterday evening I had the honour and pleasure of recording one of his famous SQL Hangout with my friend Boris Hristov (b|t).
We...
2014-04-18
247 reads
Some days ago I was talking with my friend Davide Mauri about the uniquifier that SQL Server adds to clustered...
2014-03-14
891 reads
I’m writing this post as a reminder for myself and possibly to help out the poor souls that may suffer...
2014-02-03
1,010 reads
In my last post I showed a query to identify non-unique indexes that should be unique.
You maybe have some other...
2014-01-30
990 reads
Understanding the basics of how T-SQL logic works in branching is important to ensure you code works as expected. This article will help you learn how this impacts control of flow language.
2013-06-21 (first published: 2010-12-30)
33,527 reads
Should I be formatting dates on the database side? What tools can I use in SQL Server to format and parse dates? This article helps you decide which one best suits your needs.
2012-03-23
25,116 reads
There is an inprocess setting for linked servers. Have you ever used it? Gianluca Sartori gives a look at what the implications are for this.
2011-06-09
24,046 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Not sure if this is really a relational theory question but it seems about...
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
Hi all, I recently moved to a new employer who have their HA setup...
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers