Performance Tuning with sp_BlitzIndex
Just a small blog post about how I used sp_BlitzIndex for the first and how awesome that was. sp_BlitzIndex is one...
2015-12-10 (first published: 2015-12-07)
3,220 reads
Koen Verbeeck
Master Data Services Configuration Woes
Installing and configuring SQL Server Master Data Services (MDS) is like a box of chocolates: you never know what you’re...
2015-12-01 (first published: 2015-11-24)
4,455 reads
Reporting Services redesign – it’s the little things
SQL Server Reporting Services (SSRS) is getting quite the overhaul in SQL Server 2016. Lot’s of things are changing:
new look...
2015-11-24 (first published: 2015-11-20)
4,128 reads
Reblog: Data Visualization – Book Review
To prepare myself for my session Data Visualization Tips & Tricks, I read a few books. In this blog post, I’ll...
2015-11-17 (first published: 2015-11-12)
1,338 reads
Webinar – What’s New for Business Intelligence in SQL Server 2016
I’ll be giving a webinar for MSSQLTips.com on Thursday 29th October 2015.
The title is What’s New for Business Intelligence in SQL Server...
2015-10-23
833 reads
Presentation Design – Before and After
Recently I gave a session on the SQL Server Days about the new features for business intelligence in SQL Server...
2015-10-15
468 reads
Overview of Published Articles – 2015Q3
Here is an overview of the articles I published in the third quarter of 2015.
Retrieve file sizes from the file system...
2015-10-06
469 reads
What’s new for BI in SQL 2016 – Session materials
SQL Server Days 2015 is over and it was a blast. Met a lot of people from the #sqlfamily, too...
2015-10-01
580 reads
New SSRS features in SQL 2016 CTP 2.4
SQL Server 2016 CTP 2.4 hasn’t been released yet (any day now I guess), but someone was apparently very eager...
2015-09-30
2,157 reads
Why I hate Pie Charts
The pie chart should be avoided at all costs. Why?
you can only display a limited number of slices (although that...
2015-09-21
541 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
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