-
SSRS: A Hidden Tablix That Won’t Hide And Wham!
Here’s a real quick tip after banging my head against the desk for awhile. I had a tablix in SSRS that was supposed to be hidden if there were no rows. It was working fine until, wham, it stopped working. (Oh no. I said “wham”. That obviously leads me to “Wham!”. I had my mom […]
-
Formatting MDX and DAX: Free Online Tool From Microsoft
Ever cut and paste a mess of generated MDX from Excel? How about a coworker who doesn’t know how to use the “tab” key when working in SQL Server Management Studio? I came across this no frills online MDX formatter from “Microsoft Labs” and have been using it for the last few days to clean […]
-
Parse and sort SET STATISTICS IO output with Excel
I wish I could say this was my idea. Somebody posted it on twitter awhile back and I did the classic “facepalm”. I have no idea how many times I manually picked apart the results of SQL Server’s SET STATISTICS IO ON without considering creating a formula to handle it for me. So, somebody came […]
-
Set DATA_COMPRESSION for all tables
Working on a quick little project to sync up two databases and I realized the data compression was set differently between the two of them. Apparently, my Google fu was not up to snuff because it took quite a bit of stumbling around to find a forum post matching what I wanted to do. There […]
-
SQL Server DELETE FROM: The World’s Scariest DELETE statement
It’s out there. Waiting for you. While you sleep, it’s awake. It’s coming for you. It’s the Jason Voorhees of SQL Server and you’re the teenager headed into the woods on a dark night… How can you stay safe? Well my friend, knowledge is power. (For example, if you’re a teenager don’t go to Crystal […]
-
It all comes back to the work that occurs behind the curtain…
Couldn’t have said it better… RT @lanier: “80% of #datascience is infrastructure; 20% is the fun stuff—charts etc.” – @opower at #strataconf — Michael Cavaretta (@mjcavaretta) October 24, 2012
-
Last Restore Date And Time – SQL Server Query
“How old is this data?” “When was this database restored?” “How old is this backup?” These are common question in development environments. A fast little t-sql query can tell you the following: The date and time of the last restore. The date and time the backup which was restored was originally taken. The user who […]
-
Alter Table: Add Not Null Column – SQL Server
Listen up my people. NOT NULL columns are your friend. It may take a few extra brain cells to populate it initially but the long term rewards in data quality are well worth it. (You’ll also force all your software developer cohorts to think specifically about the values they’ll be inserting into a column which […]
-
SQL Script: Distinct Column Values Across All Tables
Sometimes I wonder if some of the more random scripts I post are useful to anyone but me so if this one is useful to you definitely drop a comment below! Check it out: Our team was trying to confirm what our best practice was when creating flag columns in the data warehouse. As usual […]