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)
7,480 reads
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)
7,480 reads
A big thank you goes out to Kenneth Fisher ( b | t ) for hosting this month’s TSQL2sday party. Security is a...
2015-02-10
495 reads
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,477 reads
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,401 reads
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 Subscriptions On A Budget – Part 2
Yes, this is Part 2, you can find Part 1 here to get...
2014-11-04
1,095 reads
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 in SQL Server Reporting Services (SSRS) is only available if you have the Enterprise or BI Editions...
2014-07-01
1,046 reads
Serving on the Nomination Committee (NomCom) is such an honor. One that I was lucky enough to experience two years...
2014-06-02
427 reads
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
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
By Steve Jones
In order to generate migrations, we need to configure Flyway to use a shadow...
By Steve Jones
Today’s coping tip is to get back in contact with an old friend. This...
Hi all, I created Extended Events session to capture sql_batch_completed for duration>5 sec sending...
Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...
Hi, I have four views on one database to which one sql authenticated user...