Browse the archive
SQL Server supports two kinds of data compression on rowstore data. Columnstore compression is for a different day. You can compress heaps, clustered indexes (on both tables and views), and nonclustered indexes (on both tables and views). Compression …
Continue readingIn SQL Server, auto-update statistics is a database level setting. It’s right there: I’m not going to say whether I think Auto Update Statistics should be on or off. Instead, I’m going to argue that there are definitely scenarios when you want to have this on …
Continue readingFILESTREAM is not a particularly popular feature of SQL Server–if you’re using it, you are in the minority. If you have a database with filestream in an Availability Group, then you’re REALLY in the minority. At my 9-5, this is being done, and it’s apparent …
Continue readingI’ve been using SQL Server for a dozen years now, but I’ve only been starting to make friendships and build relationships within the SQL Server community in the last couple of years. More importantly, it has only been in the last year that I would say I have …
Continue readingWhen to use WITH OVERRIDE on your RECONFIGURE statement
Continue readingOn December 5, I’m speaking at QL Saturday #465 in Providence, RI. My session is called “Shortcuts from an Impatient DBA." This is an expanded version of my lightning talk from the New England SQL Server User Group earlier this year. It went over so well, I …
Continue readingOn December 5, I’m speaking at SQL Saturday #470 in Washington DC. My session is called “Wheaton’s Law for Technology Pros” and is based on my post “Watch your step! Don’t become a DBA-hole.” I’m really looking forward to it for lots of reasons, but in …
Continue readingYesterday was SQL Saturday #437 or as we call it, SQL Saturday Boston BI Edition. It was my first time helping to organize a SQL Saturday (or any event like this). It was an honor to be asked to join the organizing team, knowing that they already put on some …
Continue readingQuestion I have Native SSRS configured on a 2012 instance (11.0.2100). I have two reports with images that act as buttons to toggle between the chart report and the detail report. I want to configure the action URLs to dynamically pass in parameters when …
Continue readingThis blog post takes a tangent from my usual technology-specific ramblings, but I’ll make the connection eventually. Just bear with me. Dumplings Dan dan mien, mango bubble tea, and petite chicken dumplings in Sichuan sauce Today, I was craving some mapo tofu, …
Continue reading
