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) started. This month’s episode is hosted by Kenneth Fisher (blog). The topic: Backup & Recovery ## Your backups are my bread & butter Backup & recovery are a DBA's bread & butter. I …
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). You can take part by posting your own participating post that fits the topic of the month and follows …
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
