DAX IsFiltered Function
The DAX IsFiltered function returns True when <columnName> is filtered directly and false if there is no direct filter on...
2012-10-11
2,033 reads
Salvo(z) SQL
Ten SQL Kindle eBooks for Under $10
Introducing Microsoft SQL Server 201231 Days of SSIS with SQL Server 2008 R2SQL Server Interview Questions and AnswersPerformance Tuning with...
2012-10-07
1,220 reads
SQL Azure–Failed to Update because the database is read-only
An error message for one of our many SQL Azure databases was brought to my attention today.
Msg 40628, Level 16,...
2012-10-05
2,338 reads
SQL Saturday #149 Minneapolis 2012
This past weekend I attended SQL Saturday #149 in Minneapolis with my husband Adam, my brother Chris and another member...
2012-10-03
821 reads
T-SQL Tuesday – Help! I Need Somebody
By Jennifer Salvo
Today is T-SQL Tuesday #34 hosted by Rob Volk (B, T). This month’s topic is ‘Help! I Need...
2012-09-11
888 reads
Azure Virtual Machine TempDb Placement
The recommended location for the tempDb on an Azure virtual machine, is the non-persisted D: drive. This drive is actually...
2012-09-06
2,070 reads
Personal Goals
With fall quickly approaching, I thought this would be an ideal time to set some personal goals for the upcoming...
2012-09-01
1,514 reads
Book Review: Troubleshooting SQL Server A Guide for the Accidental DBA
Over the past few years, Adam and I have won several books at the local MadPASS chapter meetings. I’ve intended...
2012-08-24
2,154 reads
Meme15: Top 5 Reasons I Like My Job
This month’s Meme15 topic is ‘Top 5 Reasons I Like My Job’. A little over a year ago, I started...
2012-08-16
1,329 reads
T-SQL Tuesday: Trick Shots (Currency Conversion in SSAS)
Today is T-SQL Tuesday #33 hosted by Mike Fal. The topic is SQL Server – Trick Shots. This assignment involves blogging...
2012-08-14
951 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
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