Browse the archive
Question I create a bacpac from azure and restore to my local on-prem server. However, it throws an error like “Please create a master key in the database or open the master key in the session before performing this operation”. The reason is one of the column …
Continue readingQuestion I am a new DBA at a company that has never had a DBA before me. SQL Servers are never upgraded unless it is part of a Windows Update on the server. Service Packs (or CUs) are never installed. We have a mix of versions from 2000 to 2014.
Continue readingQuestion I just executed a query that went pretty fast and the SQL Profiler said it used 30.000 reads. Now I'm looking at this page: https://cloud.google.com/compute/docs/disks/performance and see that a standard persistent disk has 3000 reads IOPS. Does that …
Continue readingQuestion What is the MySQL equivalent of SQL Server 2016 Always Encrypted technology or is there anything similar in MySQL that can act as AE? Asked2016-12-20bydwkd Answer The Always Encrypted feature provides end-to-end encryption, which encrypts data both …
Continue readingIt’s T-SQL Tuesday, the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Kenneth Fisher (blog| twitter). The topic: Backup & Recovery ## Your backups are my bread & butter Backup & recovery are a DBA's …
Continue readingQuestion I need 1100 columns in a single table.I already have 928 columns in same table, now I need to add new 150 columns. I know SQL Server allow maximum 1024 columns. Now I will not create new table. If I create new table and join my require table, I need …
Continue readingNext month, I’ll be speaking at two SQLSaturday events. Washington, DC - #SqlSat574 - December 3, 2016 Being a DBA is like play Pac-San. Eat all the LUNs before the SAN Admin chases you away. The DC SQL Saturday was the first SQL Saturday I spoke at–so this …
Continue readingFor this month’s T-SQL Tuesday, I asked people to blog about the same old problems we’ve been dealing with for years. There were some great posts, including a batch of first-time contributors. You’ll notice some overlapping themes as you read through these …
Continue readingWhat is T-SQL Tuesday? T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam Machanic (blog|twitter). You can take part by posting your own participating post that fits the topic of the month and …
Continue readingToday, SQL Sentry announced the release of Plan Explorer 3.0. There are a few big changes, so let’s dive right in. Plan Explorer just got free-er Up until now, Plan Explorer was essentially a freemium product. There was the free edition (which was really …
Continue reading
