Exploring Excel 2013 for BI Tip #15: Locking Slicer Position
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2014-06-23 (first published: 2014-06-18)
4,293 reads
Blog Posts
ExpressProfiler: Yet another "when and why" story.
Core of ExpressProfiler was born about 8 years ago when I worked for a company whose mission was the migration...
2014-06-23
748 reads
Introduction to Latches in SQL Server
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-06-23
2,810 reads
Last Weeks Top “Reading” Links #89
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-06-23
488 reads
Plagiarism: A Community Destroyed
Personal Thoughts
Just to be clear, I don't expect everyone to have my same thoughts. I personally fully support SQLServerCentral and...
2014-06-23
482 reads
Reading, Writing, and Riskmetic-Question of the Day
Reading, Writing, and Riskmetic is another Question of the Day, this one about how to allow developers to understand performance...
2014-06-23
540 reads
sp_SrvPermissions & sp_DBPermissions V5.0
These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures...
2014-06-23
689 reads
SQL Server 2012 || Contained Database
Contained databases are the new feature in SQL Server 2012 and are defined on BOL (http://technet.microsoft.com/en-us/library/ff929071.aspx) as below :
A contained...
2014-06-23
9,288 reads
SSC Editorial: Bad Meetings or Meeting Badly
Bad Meetings or Meeting Badly is the editorial of the day today. Looking at it today, I wish I had...
2014-06-23
516 reads
The Curse of Relational Databases
Let’s face it, none of Information Technology is easy. Oh yeah, there are those few geniuses that have an absolute...
2014-06-23 (first published: 2014-06-18)
5,165 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