It’s road trip time! Next Tuesday, June 19, 2012, I’m packing up the Fit and heading west. I’ll be in Edina, MN (somewhere near Minneapolis) to present for the Minnesota SQL Server User Group, PASSMN! The group meets at 3601 West 76th Street, Suite 600 Edina, MN 55437. The meeting starts at 4:00 PM. The What, Why, and How of Filegroups Every DBA must know how to create and maintain filegroups because they affect performance, maintenance, and security of your data.
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
As you might imagine, I rely on Idera’s Diagnostic Manager quite a bit. Diagnostic Manager monitors many different things within each SQL Instance will alert to them when they met the thresholds you configure. Now if you only a few SQL Instances monitored, you may not have many alerts, but if you have dozens of SQL Instances monitored, you could have several dozen alerts all the time. Maybe some of those alerts are not going to cause your system to crash right away, but you want to keep them in mind to show your boss that you need more memory or disk space.
The Microsoft Technet site has made available a bunch of e-books in epub, mobi and pdf formats At this moment there are 11 books available, here is the list ASP.NET Deploying an ASP.NET Web Application to a Hosting Provider using Visual Studio Getting Started with ASP.NET 4.5 Web Forms (Beta) Intro to ASP.NET MVC 4 with Visual Studio (Beta) Office Configure Kerberos Authentication for SharePoint 2010 Products SQL Server Master Data Services Capacity Guidelines
How big are your core databases right now? Do you know how they got that way? Is that normal? These questions are impossible to answer just by looking at the database options dialog in SSMS. They are also questions I’ve had to try to answer in several different environments, because without logging we not only didn’t know what normal growth looked like for our system, we didn’t know what tables and indexes were driving that growth.
[]1 T-SQL Tuesday #31, hosted by Aaron Nelson this month, asked the SQL community to write about logging. Logging is an open door into many topics and could pertain to error logging, logging with monitoring, SQL Server logs, feature logs, grocery store logs of how much you spent and how you inserted it into SQL Server to average out your spending for a month…you get the picture. Originally, I had written about a different topic but recently, I was asked a question that belongs in the T-SQL Tuesday logging theme and I wanted to share it with everyone.
It’s the second Tuesday of the month, and that means it’s T-SQL Tuesday! This month’s topic, brought to us by Aaron Nelson (twitter | blog), is Logging. SQL Server logs many, many pieces of information. All of these are valuable when there are problems with the server. What happens when there is a problem with a Reporting Services instance or report, though? Those errors are not written to the SQL Server error log.
For the unfortunate souls not in the know (or is it the fortunate souls using one of the myriad alternatives?), SquishIt is a library used to optimize content delivery at runtime in ASP.net applications. It combines and minifies javascript files, and also does a bit of preprocessing for things like LESS and CoffeeScript. I’ve been working with Justin Etheredge (blog|twitter) on this for a while, first on patches for various bugs I encountered trying to use SquishIt on linux, but more recently my focus has been on improving extensibility.
To sum up my latest adventure, Tech on Tap v1.2 SharePoint, here’s a simple Top 10 List – in no particular order. The Stone Cellar Brewpub Scottish Ale. This was a smooth, rich beer. Yum. Four excellent speakers: Chuck Heinzelman, from Microsoft SQL Server CAT; Rob Bogue, a SharePoint consultant and MVP; local consultant Rick Fischer; and David Peterson from Trek Bicycle Corporation. This diverse group brought a wide range of experiences and knowledge.
Where I work, we like to buy Diagnostic Manager Licenses in batches. So every quarter or so I add in a bunch of new instances. When you start getting over 25 instances being monitored, it gets tricky to remember which 5 instances you just added into the mix. One solution that I like to use, is to create a “New Server” tag and slap it on each server as it add it.
At my last job we had a non-functional attribute that another team used to decorate service methods that they consumed. The other team was working on an alternative client to our WCF services, and they weren’t on the same release schedule they needed to be able to target multiple versions of our services within a single version of their application. Because of this requirement, they maintained a wrapper around our services that handled some of the differences between versions.