Automating SSAS Backups
Backing up databases is one of the most important jobs of a DBA. If your data is not safe, your...
2015-02-23 (first published: 2015-02-11)
8,144 reads
SQL Swimmer
Managing Security – TSQL2sday # 63
A big thank you goes out to Kenneth Fisher ( b | t ) for hosting this month’s TSQL2sday party. Security is a...
2015-02-10
497 reads
Transaction Isolation Level Blues
Have you ever had a mental block in one particular area when learning something? It might be the simplest thing,...
2014-12-25 (first published: 2014-12-15)
5,482 reads
Giving Back T-SQL Tuesday #61
First off I wanted to thank Wayne Sheffield (Twitter | Blog) for hosting this month’s T-SQL Tuesday party and Adam Machanic...
2014-12-12 (first published: 2014-12-09)
4,404 reads
Summit 2014
It’s hard to believe it’s over. It felt like a whirlwind while I was in Seattle for my 7th PASS...
2014-11-10
462 reads
Data Driven Subscription On A Budget, Part 2
Data Driven Subscriptions On A Budget – Part 2
Yes, this is Part 2, you can find Part 1 here to get...
2014-11-04
1,099 reads
I Didn’t Hyperventilate!
I gave what is officially my second presentation this week. I presented at the Triad SQL BI (Twitter | PASS) user...
2014-08-28
1,283 reads
Data Driven Subscriptions On A Budget
Data Driven subscriptions in SQL Server Reporting Services (SSRS) is only available if you have the Enterprise or BI Editions...
2014-07-01
1,048 reads
2014 NomCom Slate is Amazing
Serving on the Nomination Committee (NomCom) is such an honor. One that I was lucky enough to experience two years...
2014-06-02
429 reads
Disheartening Apples
Question: How many Oracle DBAs can you fit in Madison Square Garden?
Answer: None, their egos won’t fit through the door.
No,...
2014-03-21
630 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers