Back home from the PASS Data Community Summit
What a week it was. While it wasn’t my first in person conference this year, it felt different. For the past 20+ years, the Summit has been one of the standard parts of my year. It was always marked on my calendar as where I would be, and for yea …
Why Haven’t You Disabled SA? Wrong Answers Only.
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong answers only.” The results were pretty funny: “I went a step further and also created an account called ‘as’. Now my …
Strategies for queries against bit columns
Recently someone posted a question where they couldn’t quite figure out how to construct a predicate based on a bit parameter. They tried to write a procedure like this, which wouldn’t parse, of course: CREATE PROCEDURE dbo.whatever @flag b …
“How do my peers do this?” The latest best practices for IT architects implementing a major business initiative
The post “How do my peers do this?” The latest best practices for IT architects implementing a major business initiative appeared first on SQLServerCentral.
What are Warehouses in Microsoft Fabric?
The post What are Warehouses in Microsoft Fabric? appeared first on SQLServerCentral.
PASS Summit 2023 – Community Keynote – AIOps and ChatGPT – Prepare to Ride the Next Wave
Last but not least, the Community Keynote. Hang on to your hats, this is going to be an interesting ride! President/Founder of SQL Skills – Kimberly Tripp Surprised people make the Friday keynote. Agreed. This is hard and exhausting! On day to go …
Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points.
The post Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points. appeared first on SQLServerCentral.
How to get your security team on board with your cloud migration
The post How to get your security team on board with your cloud migration appeared first on SQLServerCentral.
Scheduling SQL Agent Jobs on Alternating Weeks
Bi-week… semi-week… fortnight… « every two weeks » Recently on the SQL Community Slack group, someone asked if there was a way to schedule a backup to run on alternate weeks. I’m not exactly sure why (maybe they wanted to run full and differential …
PASS Summit 2023 – Redgate Keynote – The New Database Landscape – Revealing Shifts and Charting the Next Horizon
Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence! <image to be added> Carly Miechen – Redgate Events Welcome to day 2. Let the Event team this year! (Great job Carly). Carly’s fifth PASS (first in …
[Video] Office Hours at Megunticook Falls in Camden, Maine
While in historic and beautiful Camden to hang out with friends, I went to Megunticook Falls and answered your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:05 Mike: Hi Brent. You’ve mentio …
PASS Summit 2023 – Microsoft Keynote – Limitless growth, limitless opportunities: Data and innovation in an AI world
CEO of Redgate: Jakub Lemik: This year’s theme is Connect, Share, and Learn. Tomorrow will be People are here from 44 countries. The summit has 5 tracsk, 232 sessions with 231 speakers! 43% of attendees are first timers! Thank you sponsors! …
Office Hours, Silent Film Edition
Hey, remember in yesterday’s video how I said I was having a really bad day? Well, here’s how bad it was – I recorded two videos in a row, and I forgot to turn my microphone on for the second video. <sigh> So here are the questi …
SQL Server Table Design Guidelines – Data Types, Designing for Deletes and Primary Keys
The post SQL Server Table Design Guidelines – Data Types, Designing for Deletes and Primary Keys appeared first on SQLServerCentral.
How to join the free PASS Data Community Summit Livestream from around the world
There’s nothing quite like attending PASS Data Community Summit in person to reconnect with friends and make new professional connections to boost your career. With Summit 2023 just around the corner (15-17 November, Seattle, WA), if you’d like to atte …