Archives: January 2012
As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections (a part of the greater DevConnections event) in Las Vegas, NV, on March 26-29, at the MGM Grand Hotel. This is in addition to the SQL Server tracks that are… Read more
Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of you, identifying what is the best way to move forward for you is vital.
Last week I received an email from a reader who was looking for some advice on… Read more
I had a situation today where I needed to ensure that the dedicated Administrator connection (DAC) ran on a specific port.
The main reason that I wanted it on a specific port was so I could use the connection remotely (if needed) and because the connection was on… Read more
I’ve had making home made ice cream on my list of things to try for a while, since watching an episode of Good Eats. Just never got to it as kid, seemed like a good thing to do now with my own children. I spent all of 5 minutes browsing… Read more
The first ever Tech on Tap event was held on Saturday, January 27th, 2012 at the Stone Cellar Brewpub in Appleton, WI. If you weren’t there, well, you missed it. Notice that keyword in that earlier sentence, Brewpub. Yes, the Tech on Tap events (and there will be more) are… Read more
This article explains how to send an email through Powershell.
Very useful if you have a requirement to automate your scripts and send notifications .
The example is calling the SmtpClient Class , which is part of the .Net Framework.
You can call a Function – which makes your scripting … Read more
Charts present summary data in a visually appealing format. Following is a chart for sales over month:
I frequently use a few options along with charts to get most out of them.
Show data labels:
It’ll be easier for the users to quickly read, if the chart shows… Read more
Over the next few weeks / months there will be plenty of opportunities to meet the Geniiius family, since we started the company we have not done many public presentations. This is something that we will start to do more of in the following months, and hopefully after the summer… Read more
I have come accross below link while checking options to find top painful mirroring enabled databases.
Looks like there is no single query/DMV to get this info.
back to this link.
Excellect collection of key notes for almost all key SQL topics. Great work Jose Barreto.
Good source for Senior… Read more
One of the most exciting features in SQL Server 2012 is the introduction of the Tabular Model. The Tabular model along with the multidimensional model comprise the Business Intelligence Symantec Model (BISM).
To be honest when the Tabular Model and the BISM where introduced along with DAX I… Read more
0 comments, 2,445 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 31 January 2012
The new version of the lovely SQL Server edition, Express Edition!
Take a look the new link for the download and you have many possibilities for the download - (32/64 bit, multilingual etc).
Stay Tuned! Read more
SELECT * FROM
WHERE BLOCKED != 0
0 comments, 1,062 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 30 January 2012
Breaking Down TempDB Contention (part 2)
I wrote a somewhat popular script and blog post a while back called Breaking Down TempDB Contention. This post explains how to identify tempdb contention. This past Friday, Jonathan Kehayias (blog|@SQLPoolboy) contacted me… Read more
8 comments, 1,854 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 30 January 2012
I needed to return an identity value recently from an insert for use in another piece of code. For a client front end, you can easily encapsulate your insert in a stored procedure and then SELECT scope_identity() to get the last identity. However there’s an easier way: the output clause. Read more
I am officially announcing that I have now become an independent consultant and business owner. Becoming independent has always been my dream and I have now decided to follow that dream. I believe it is the right time to do it for my family and myself. It’s time to soar! Read more
While using a cube in SSAS is usually a great source for reporting, it is not always the best choice. Sometimes it is better to report off of the data warehouse that the cube is built from.
For example, say you want to create a P&L statement using a financial… Read more
The Idera ACE program is something I’ve been involved with for over a year now. I’ll share a bit of the back story, and some thoughts on how the idea has grown and morphed since then.
Back in late 2010 I had a couple conversations with David Fargo and Heather… Read more
Last time I dealt with the creation of subdirectories, in one or more root locations, to house my database backups. Today we’ll get into the meat of the database backup procedure itself. If you’ll recall, this procedure has to meet some specific criteria:
- It will need a minimum of…