Three big reasons T-SQL still beats the GUI – a MinionWare snippet
We like code better than mouse clicks for three basic reasons: T-SQL lets you do more. T-SQL lets you share your process. T-SQL lets you keep a record.
The...
2020-05-27
8 reads
Jen McCown
These five SQL tools are essential for 2020 – a MinionWare snippet
You’re going to need some solid SQL tools. Here are the five absolutely essential tools for SQL Server shops, as agreed on by the MinionWare team.
The post These five...
2020-05-19
58 reads
These five SQL tools are essential for 2020 – a MinionWare snippet
You’re going to need some solid SQL tools. Here are the five absolutely essential tools for SQL Server shops, as agreed on by the MinionWare team.
The post These five...
2020-05-19
10 reads
What to Pack for PASS Summit
In checklist form! Absolute I-probably-won’t-survive-without-this ESSENTIALS Wallet Prescriptions Glasses/contacts Phone and cord Laptop and cord (okay, maybe this is just me) A jacket (after all, Seattle) Generally A GOOD IDEA...
2019-10-29
23 reads
What to Pack for PASS Summit
In checklist form! Absolute I-probably-won’t-survive-without-this ESSENTIALS Wallet Prescriptions Glasses/contacts Phone and cord Laptop and cord (okay, maybe this is just me) A jacket (after all, Seattle) Generally A GOOD IDEA...
2019-10-29
5 reads
All about PASS Summit 2019
Here are the things you must/should probably know about PASS Summit 2019, as told by me. Included: Advice for first timers Prioritized schedule at a glance Sessions we recommend...
2019-09-23
40 reads
Trouble writing? Join the club. #JustWriteTech
I was talking with a couple of excellent SQL people* recently, and we were bemoaning the difficulties and disciplines of blogging. This is what speakers do after a successful SQL...
2019-09-19
38 reads
Use T-SQL, not the GUI
There’s a very good reason to do most of your DBA work using T-SQL, and not the SSMS object explorer. Let me tell you about it...
The post Use T-SQL,...
2019-08-23
60 reads
Beginning T-SQL and Career Roadmap for Women (and Men)! #SQLSatBR
Download session materials and watch the recordings of my excellent sessions on Transact-SQL and IT careers! I'm looking especially at you, women in technology!
The post Beginning T-SQL and Career...
2019-08-19
30 reads
Big fall conference – PASS Summit schedule is up!
PASS Summit 2019 now has a schedule and learning tracks, and a letter to convince your boss you should go!
The post Big fall conference – PASS Summit schedule is...
2019-08-14
58 reads
Blogs
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers