String or binary data would be truncated: get the full picture in SQL Server 2017
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server...
2018-10-31
504 reads
Randolph West
- Twitter: @_randolph_west
- Website: https://bornsql.ca/blog/
- LinkedIn: https://linkedin.com/in/rabryst/
Create a slipstream installer for SQL Server on Windows
Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL...
2018-10-24
227 reads
Fix SQL Server with one click
Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration...
2018-10-17
291 reads
Changes to the SQL Server servicing model (Cumulative Updates)
On Monday of this week, Microsoft announced changes to the servicing model for SQL Server, starting with SQL Server 2017....
2018-10-10
315 reads
What is a DBA anyway?
Some time ago we started a new series here, called Database Fundamentals. The very first post in that series asked...
2018-10-03
283 reads
Azure means hybrid now
On Monday 24 September 2018, Microsoft announced a slew of stuff at their annual Ignite conference that is going to...
2018-09-26
346 reads
Public Service Announcement: check your backup notifications
The Azure cloud platform lost a data centre for a number of hours recently due to inclement weather. This affected...
2018-09-19
225 reads
Bulk insert issue with UTF-8 fixed-width file format
Fellow Canadian Doran Douglas brought this issue to my attention recently, and I wanted to share it with you as...
2018-09-12
288 reads
Relational databases aren’t the problem
Content warning: This is the first of two rebuttal essays, about why someone is wrong on the Internet. It is...
2018-09-10 (first published: 2018-08-22)
3,147 reads
Dates and Times in SQL Server: AT TIME ZONE
Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the...
2018-09-05
258 reads
Blogs
Azure Networking: Designing for Change
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
Using Customer Docker Compose File Names
By Steve Jones
As I use containers more and more to run various things, I decided I...
SQL Server Failover Cluster Instances
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
Forums
Spirit Airlines
The Spirit Airlines Newark Liberty Airport Terminal is well integrated into the broader transportation...
SQL Server authentication vs. Trusted connection
I maintain an application written years ago, where the database is on a Windows...
Handling Engagement Rings & Wedding Band
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers