Data Quality
Around the years 2000 to 2005, the trade press filled with articles on data quality. Several good books (see references) were written on the subject, and then it seemed to fade from the popular view. It really is something that should be taught in data …
Adding Disks – Level 3 of the Stairway to SQL Server on Linux
In this level we examine how to add disks to separate our data, log, and tempdb files.
SQL SERVER – Unable to Uninstall – Index was Outside the Bounds of the Array
This was an interesting error which I received while trying to uninstall SQL Server. In this blog, we would learn how to fix error Index was outside the bounds of the array, which might come during uninstallation of SQL Server. I must say this wa …
Indexed View Creation And Underlying Indexes
Accidental Haha While working on some demos, I came across sort of funny behavior during indexed view creation and how the indexes you have on the base tables can impact how long it takes to create the index on the view. Starting off with no indexes, t …
PackPrecScale CLR function
CLR can be used to pack Precision and Scale of a SqlDecimal How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottleneck …
Create, protect and manage non-production databases with SQL Provision
SQL Provision allows teams to create a secure, scalable and repeatable process for managing data as it moves through your SQL Server estate, without causing administrative burdens. To find out more and how it can work alongside your existing database D …
Overview of Azure SQL Database Information Protection
Information protection becomes one of the dominant factors that drive modern database design and implementation. This becomes particularly evident when operating in a cloud computing environment, with Azure SQL Database serving as one of the prime exam …
SQL SERVER – The OLE DB Provider “Microsoft.ACE.OLEDB.12.0” for Linked Server “(null)” Reported an Error. Access Denied
Here is another blog which explains a situation I was in while reading data from excel. In this blog, we would talk about error “Access Denied” error while using The OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server. …
How to Log Active Queries with sp_BlitzWho
Queries are running when you’re not around. They’re wreaking havoc – maybe they’re filling up your TempDB, or causing blocking, or flushing your buffer pool out. When I wanna see what queries are running, I run sp_BlitzWho: That …
Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package
In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.
Cost estimation for SQL Server Azure VMs
This article provides pricing guidance for SQL Server virtual machines in Azure.
Monitoring Changes in Permissions, Users, Roles and Logins
Compliance means keeping a close grip on any changes to the permissions and access control of a database. Sadly, the law has had to acknowledge, from bitter experience, that it is not just external intruders who want to do this, but it could also be at …
SQL SERVER – Small Backup for Large Database
Recently, I had a very interesting experience with one of my customer while working with them on Comprehensive Database Performance Health Check. The issue was related to small backup for the large database and it was so much interesting I decided to s …
[Video] Office Hours 2018/11/28 (With Transcriptions)
This week, Brent, Tara, and Richie discuss storing phone numbers in a database, forced parameterization, how AI will affect DBA jobs in the future, what languages a DBA needs to learn, backup issues, measuring the overhead of transparent data encryptio …
How to Start Database in a Single User Mode? – Interview Question of the Week #202
Question: How to Start Database in a Single User Mode? Answer: We all needed one time or another time this particular help. Whenever there is a corruption or any issue with SQL Server where we need to stop access from external users/system. We hav …