Brute Forcing SQL Logins and Passwords
Watch this week's video on YouTube
Following up on last week's post about the different types of SQL injection, this week I want to show how injection can be used...
2018-11-27
12 reads
Thinking about Pre-Cons In Orlando in 2019
In the spirit of “do more” we’re hoping to host at least 4 pre-cons in Orlando in 2019. Right now...
2018-11-27
273 reads
Email Notifications in Azure Data Factory: Failure is not an option
(2018-Nov-27) When something goes wrong with your data transformation process in Azure Data Factory, the last thing you expect to happen...
2018-12-11 (first published: 2018-11-27)
9,610 reads
TDE and DDM
Someone asked a question about TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking), which are two different technologies that...
2018-12-13 (first published: 2018-11-26)
2,176 reads
Things That Drive a DBA Crazy When Starting a New Job
In the past 5 months I have started two different jobs, so that leaves it up in the air as...
2018-12-07 (first published: 2018-11-26)
3,102 reads
Create dynamic agenda slides with PowerPoint Zoom
There was a time when I saw PowerPoint as a necessary evil – a way of conveying ideas that I wasn’t crazy about, but which worked. These days, my...
2018-11-26
35 reads
Forcing a Plan That Has a Plan Guide
The question that came up during a recent class I was teaching was: What if you have a plan guide...
2018-12-11 (first published: 2018-11-26)
1,830 reads
Getting the SQL Version from a backup using dbatools ………. on PowerShell Core
Following an upgrade to SQL Server the backup share had a number of backups, some from the old version and...
2018-12-12 (first published: 2018-11-26)
1,734 reads
My backup script (where, how, how big, etc.)
A while back I wrote about how to find where your backups are. And I’ve also written about I use...
2018-12-10 (first published: 2018-11-26)
2,094 reads
Ghosts in your Database
Yes Virginia, there are ghosts in your database. More specifically, there are ghosts in your SQL Server database. They are not there to haunt you. They are not there...
2018-11-26
24 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers