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
1,832 reads
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,208 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,308 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
817 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
883 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
1,960 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,509 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,089 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,320 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
914 reads
Blogs
Microsoft Build event announcements
By James Serra
There were a number of data platform announcements at Microsoft Build yesterday that I...
Data is not immutable
Information — in the form of data — usually stored as binary 1s and...
Daily Coping 25 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SQL Server Data Discovery and Classification - times out...
The powers that be have commanded that we implement data classification because... well, to...
How to Navigate through folders to find .zip file
Is there any script task in SSIS to find the zip files under each...
Ask SSC