Question 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 … [Read More]
Next month, I’ll be speaking at two SQLSaturday events. Washington, DC – #SqlSat574 – December 3, 2016 The DC SQL Saturday was the first SQL Saturday I spoke at–so this one will always be a special event for me. Hopefully, I’ll be able to speak at … [Read More]
For 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 responses–I think those themes represent some … [Read More]
PASS Summit has tons of opportunities to meet like-minded folks, in addition to seeing old friends. There are the Women In Tech and Birds of a Feather Luncheons. There is the Community Zone. Friends catch up over coffee and meals. There are vendor parties. There … [Read More]
Back in August, Allan Hirt (blog|twitter) tweeted: In the roughly 25 years of I have been in IT, we're still dealing with the same problems. — Allan Hirt (@SQLHA) August 30, 2016 I had a slow day, so I generated a storm of responses. This month’s T-SQL … [Read More]
What 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 … [Read More]
Today, 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 awesome), … [Read More]
Question I have like 20 Listners on 2014 with approx 500 DBS, what is the best way to migrate these with least downtime, effort My idea is: Stop access Backup dbs Start restore dbs While restore is running: Drop AOG on 2014 Create it on … [Read More]
Have you ever wondered what the best option is for making your data available in your environment? I was asked by Carlos L Chacon (blog|twitter) to be part of a panel on his podcast for an episode discussing some of the options–availability groups, mirroring, log shipping, and replication. We … [Read More]
Question So I have a bit of a problem with some databases I’m trying to migrate to amazon RDS We have about 20 Databases that are all derivatives of others that all share the same family_guid because they are based on backups of others. The … [Read More]
Copyright © 2024 | Andy Mallon | am2.co