Archives: June 2013
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront. As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.
Some posts from… Read more
Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI solutions, Microsoft has changed its name a few times. You know, to make it less confusing. Here’s a nice overview:
- BIDS or Business Intelligence Development Studio. The most non-confusing name…
Different ways to find FreeSpace in all disk drives of a given server
- Using WMIObject
All three methods are explained below
This post illustrates the simplest way of doing anything with ease using Powershell. I hope everyone agree with it.
Download the code here Code- DiskSpaceUsageDetails
TSQL Read more
Wow, Visual Studio 2012 is just out of diapers and here comes the next version!
Microsoft officials released the preview of Visual Studio 2013 at the Microsoft Build 2013 developer conference on June 26 (along with TFS 2013). Download here. Meanwhile, many of the new hybrid application lifecycle management… Read more
I have been working on a project recently to collect system metrics of a SQL Server environment. One of the items that came up that would like to collected is the date that SQL Server was installed on the server. In doing a quick search on where this property would… Read more
Today, going on all day, is the Summer Performance Palooza 2013, hosted by the PASS Performance Virtual Chapter. It is a virtual parade of SQL Server webinars and super speakers delivering terrific tele-training into your living room, or whereever you are. Check out the link for on-going… Read more
Those who do know me, will know that I have been presenting a session this year titled “Natural Born Killers, performance… Read more
We’re blessed in the SQL Server community that there are so many people willing to share work they have done for the benefit of others. I’ve collated five scripts that have really helped me out over the years by some of the best in the business, enjoy…
Paul Randal –…
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Under some preconditions SQL Server is able to cache Temp Tables. Caching Temp Tables means that SQL Server doesn’t have to recreate them, when you are creating the same Temp Table… Read more
Next month Mike Davis and myself will be making a epic road trip. We will be flying into Columbus, OH to deliver a two day (7/16 – 7/17) workshop on advanced Reporting Services techniques. We will then pack up and drive to Cleveland, OH for another two day (7/18-7/19) workshop… Read more
This week I got to visit Atlantis. Not the mythical island, but rather the ship, the Space Shuttle Atlantis at Kennedy Space Center. The visit was part of my summer vacation, spoiling myself by doing something with my family almost every day. The official ‘launch’ of the exhibit is… Read more
You must be really busy spinning up VMs to test SQL Server 2014 CTP1 and Windows Server 2012 R2 preview.
If your on-premise desktop computer/laptop is running low on resources and if you don’t want to take the pain of handling multiple VMs locally,then you have an option to test… Read more
I'm speaking at SSWUG Summer Camp! Thankfully, I can be at home, in my pool AND be at summer camp (oh, how I love modern technology!). If you have the time, come listen to me blather on about SSIS. http://www.sswug.org/vc Read more
I was pleased to see the email this morning announcing that community volunteers Erin Stellato, Ryan Adams, and Tamera Clark will be joining Board members Sri Sridharan and Rushabh Mehta for the 2013 Nominating Committee. More information on the election site.
The work of the NomCom is not glamorous… Read more
How will you back out if your change doesn’t work?! Always take a backup! There should always be a back out script to go with any change script! These are things that have been drilled into me time and time again. Sometimes by management, sometimes by bitter experience. If I’m… Read more
What an interesting week this has been. On Monday Microsoft and Oracle announced a partnership that rocked the cloud world. Oracle will certify its software to run fully-supported on Microsoft Windows Server Hyper-V and within Microsoft’s Azure cloud service. This list of software includes the Oracle Database, Weblogic,… Read more