SQL SERVER – Identify the column(s) responsible for “String or binary data would be truncated.”
I am happy to write this blog post as I am really happy that finally, SQL Server Engineering team has decided to fix the error which we all have been struggling for many years. I will say Since the year 2000, I have been working with SQL Server and it …
How are you using tools to design and model databases?
The post How are you using tools to design and model databases? appeared first on SQLServerCentral.
Introduction to SQL Server Security — Part 4
The post Introduction to SQL Server Security — Part 4 appeared first on SQLServerCentral.
Using the SQL Monitor Estate Pages
The post Using the SQL Monitor Estate Pages appeared first on SQLServerCentral.
How to Compile Queries and Not Execute Them? – Interview Question of the Week #219
Question: How to Compile Queries and Not Execute them?Answer: Have you ever heard this question before? Honestly, I have heard it before and I even wrote about this on this blog many years ago. Here are two of the earlier example.SQL SERVER – Wha …
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘SSIS_hotfix_install.sql’ Encountered Error 15151
Recently I was helping a client where SQL Server upgrade was failing with an error. If you have seen my blogs, there have been many blogs where I explain steps to fix upgrade-related issues. In this blog, we would learn about fixing another cause of sc …
SQL SERVER – Error in Validation: Listener in Workgroup – Unable to determine if the computer exists in the domain ‘WORKGROUP’
There are many deployments where I have assisted my clients in creating Always On Availability Groups. Sometimes they come to me with special requirements, based on their infrastructure, and I always learn from them. In this situation, my client was tr …
A Database Developer’s Guide to SQL Clone
The post A Database Developer’s Guide to SQL Clone appeared first on SQLServerCentral.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘msdb110_upgrade.sql’ Encountered Error 8649, State 1, Severity 17
While trying to upgrade my SQL instance to the latest patch of SQL 2017, I encountered an issue. This has happened earlier with a few of my clients earlier but this time the cause was different. In this blog we would learn about cause and the fix of up …
Crosstab queries using PIVOT in SQL Server
The post Crosstab queries using PIVOT in SQL Server appeared first on SQLServerCentral.
How to Monitor IDENTITY columns to prevent unplanned downtime
The post How to Monitor IDENTITY columns to prevent unplanned downtime appeared first on SQLServerCentral.
Glenn’s Tech Insights For April 3, 2019
(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …
What You Said You’re Going to Do About SQL Server 2008
Last week, I asked you what you were going to do about SQL Server 2008’s fast-approaching end-of-support date. Countdown clock at SQLServer2008.com Here were some of my favorite responses from blog comments and Twitter. Terry’s been doing a …
SQL For Cosmos DB – Tips and Tricks
The series so far: Introduction to SQL for Cosmos DB SQL For Cosmos DB – Tips and Tricks This article will help you extend your basic Cosmos DB SQL querying abilities. Here, you will learn a few of the tricks that you might need to overcome the l …
Intel Cascade Lake-SP Processor Analysis for SQL Server
IntroductionOn April 2, 2019, Intel had their Data-Centric Innovation Day, where they announced and described a number of new products for data center use. Most relevant from a SQL Server perspective is the 2nd Generation Intel Scalable Processor famil …