Calling a Stored Procedure from PowerShell
One of the DBAs at our company recently wanted to execute a stored procedure to get data from some of our databases. We have a number of databases that are used by different customers, all of which are the same in terms of the schema and objects. The d …
SQL Server Management Studio Connection to Integration Services Error Class Not Registered
The post SQL Server Management Studio Connection to Integration Services Error Class Not Registered appeared first on SQLServerCentral.
[Video] The Top 10 Developer Mistakes That Won’t Scale on Microsoft SQL Server
You’re a C# or Java developer building an application that stores data in Microsoft SQL Server, and you want to avoid common pitfalls that will cause you scalability problems down the road. In this session from my live stream, you’ll learn …
How to Uninstall SQL Server 2019 Instance? – SQL in Sixty Seconds #093
Earlier this week, I had posted a video about how to install SQL Server 2019. I received lots of comments and feedback about this one. Many people said that they have realized that installing SQL Server 2019 is very easy but the real challenge is to un …
Change the Instance Collation by Rebuilding Databases in SQL Server 2017
As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should …
How to Install SQL Server 2019? – Interview Question of the Week #287 – SQL in Sixty Seconds #092
Question: How to Install SQL Server 2019?Answer: This is one of the unique blog posts in the history of SQLAuthority where I am merging two of the blog post category together 1) SQL in the Sixty Seconds 2) SQL Interview Questions and Answers.Lots of pe …
SQL SERVER 2019 – Disabling Scalar UDF Inlining
I have been blogging for over 13 years and have been working with SQL Server Performance Tuning for an over a decade and everyone always ask me where do I get new content to write from every single day. My answer is very simple, I actually get new thin …
Temporary Tables in SQL Server
Temporary tables are just that. They are used most often to provide workspace for the intermediate results when processing data within a batch or procedure. They are also used to pass a table from a table-valued function, to pass table-based data betwe …
Recovering Scripts After SSMS Crash
It happens to the best of us and this post is more of a reminder for myself the next time it happens to me than anything else. You are working in SQL Server Management Studio, you have a few tabs open (OK, it was 123 this time, but lets stay focu …
A One-Slide Summary of the Differences Between TDE and Always Encrypted
The folks on Twitter liked this, so sharing it here: It’s a one-slide summary from a SQL Critical Care client’s deck, so obviously it’s abridged, but I think it does a pretty good job of summing things up. Some highlights of the conve …
Install MongoDB on Windows – SQL in Sixty Seconds #091
SQL Server is my passion and I have been keeping busy most of the time in my career doing. While SQL Server is my primary expertise, I also focus on MariaDB, PostgreSQL, MySQL and many other relational databases. However, in the real world, it is not a …
Tracking use of Deprecated SQL Server Features
The post Tracking use of Deprecated SQL Server Features appeared first on SQLServerCentral.
SQL in Sixty Seconds – Need Your Feedback
I have been writing about SQL Server Blog for over 13 years now and I have been also creating various different videos on SQL Server Performance Tuning topics. I have recently decided to spend more time in building the videos and have created three vid …
Honorifics in the 21st century
I have been a data professional on and off since my first full time job in 1997, though my work with data started long before that when I would catalogue my family’s music collection in a spreadsheet. Categorizing things is part of our nature as data p …
Getting Started with Azure Blueprints
The post Getting Started with Azure Blueprints appeared first on SQLServerCentral.