(Koen Verbeeck) In the Integration Services (SSIS) catalog, there are several options for the built-in logging. These options are called logging levels and they control the granularity of the logging when SSIS packages run in the catalog. Which logging level should we choose for which scenario?
Tag: sql server
TIL: Columnar Encryption Might Be Susceptible to Abuse
I was reading a post talking about some SQL encryption technologies and statements (because, you know, that’s what I do just sitting around…) and found a new potential vulnerability that I’d never really considered before. I don’t pretend that I know *all the things* about security and encryption – it’s a constant process to keep learning and figuring out what […]
SQL Server Backup / Restore from URL
(blobeater) I think many have covered how you should backup your SQL Server database to Azure storage (also known as backup to URL) but what about restoring?
The curious case of CHAR(0)
(Kenneth Fisher) Over the years I’ve seen quite a few strange things with SQL Server. This one may not have been the oddest, but it was definitely up there. A user asked me to help them copy a hashed password from one server to another.
Compare Estimated and Actual Query Plans and Related Metadata – Analyzing SQL Server Query Plans – Part 4
(Pinal Dave) I recently released a Pluralsight Course Analyzing SQL Server Query Plans, and it is really doing great in terms of viewership and I have received some really great comments and feedback about this course. This week, I will be discussing different aspects of Analyzing SQL Server Query P
Scalar functions in SQL server 2019, part 2
(Tibor Karaszi) In my earlier blog post, I focused on scalar functions that performs I/O, meaning they have at least one SELECT. For this post, I will focus on the opposite.
SQL Server Transparent Data Encryption Alternative Solution – NetLib Security Encryptionizer
(Jeremy Kadlec) Balancing new initiatives with operational best practices at our organization is always a challenge. To stay competitive in the market, we need to be constantly innovating new solutions to improve our customer experience.
Create Efficient Query Plans Using Query Store – Analyzing SQL Server Query Plans – Part 3
(Pinal Dave) I recently released a Pluralsight Course Analyzing SQL Server Query Plans, and it is really doing great in terms of viewership and I have received some really great comments and feedback about this course.
That slippery slope
(Kenneth Fisher) We need to have processes and rules. They are important to any business. That said, exceptions are also going to be a universal constant. Without exceptions to the rules you can’t deal with the unexpected/unforeseen. So what’s the problem? Ever heard one of these?
How to create a table using SQL Server Management Studio
(Gauri Mahajan) Tables are one of the most-used database objects in SQL Server databases and their design is fundamental to both DBAs and database developers. These tables are the building blocks of the majority of the SQL databases and the appropriate table structure ensures correct data is stored