Latest Blog Posts
Temporary Post Used For Theme Detection (6a375569-f9c1-4835-a7fb-fa1ba0b240e4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (e621c360-788f-48aa-bd56-670930569ab5 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
0 comments, 0 reads
Posted in Tim Mitchell on 25 May 2013
Have you configured Database Mail to utilize multiple SMTP Accounts ?
Lets start discussing about this subject by closely looking at the term Redundancy. What is redundancy all about ?
Wikipedia defines redundancy as “In engineering, redundancy is the duplication of critical components or functions of a system with the intention of increasing reliability of the system, usually… Read more
0 comments, 64 reads
Posted in SQLSailor.com on 24 May 2013
SQL – SQL Server Script to Iterate and Pull Data from All SQL Instances – Database Backup
This Post is a continuation of my previous post. Many times, there is a difficulty in pulling the data to centralized server. As I’ve already mentioned in my previous post PART1, I’m explaining how to pull the DATABASE BACKUP information from all listed instance
In order to execute the… Read more
0 comments, 80 reads
Posted in PowerSQL By Prashanth Jayaram on 24 May 2013
Reblog: May 17 to May 23
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
0 comments, 73 reads
Posted in StrateSQL on 24 May 2013
A Little Azure Fun on Friday
You know how we’ve always heard that sp_msforeachtable and other similar undocumented functions may not be supported in future versions of SQL Server? Have you tried running something like this on any of your Windows Azure SQL Databases yet:
EXEC sp_msforeachtable 'select ''?'', count(*) from ?'
Try it out.
0 comments, 41 reads
Posted in The Scary DBA on 24 May 2013
When will we look back at this?
It’s amazing how software has advanced. I look at the software I use, and I’m amazed. I still remember texting to 40404 for basic twitter usage on my Windows 6.5 Mobile. That seems miles away from the apps I know use on my current iPhone 4S. I almost can’t comprehend… Read more
0 comments, 38 reads
Posted in The Voice of the DBA on 24 May 2013
Connecting Windows Server 2003 VM To External Network In Hyper-V
The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to my physical network adapter (wifi) via the External Virtual Switch that I setup in Hyper-V (Windows 8 Pro host). I can connect to the internet to do Windows updates on those VM’s. Read more
0 comments, 244 reads
Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 24 May 2013
Performing an INSERT from a PowerShell script
This code demonstrates how to do an INSERT into SQL Server from a PowerShell script using an ADO.NET command object with strongly-typed parameters. This script issues a DIR *.* command and inserts the results to the database. While this example is not particularly useful, it is hopefully very simple and… Read more
0 comments, 28 reads
Posted in New York City .NET on 24 May 2013
Book Review – Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.
Today I will talk about a book titled ” Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.
When I first heard that Ed Wilson is writing a book on Windows PowerShell I was greatly excited. I am a great fan of PowerShell and by all means… Read more
0 comments, 103 reads
Posted in SQLSailor.com on 23 May 2013
A Rickety Stairway to SQL Server Data Mining, Part 13: Using CLR with Analysis Services
by Steve Bolton
I was drawn into the realm of SQL Server in a roundabout manner thanks to Visual Basic. Around the time I got my Microsoft Certified Solution Developer (MCSD) certification in VB 6.0 (at precisely the same time .Net hit the market, instantly leaving me a year or… Read more
0 comments, 153 reads
Posted in Multidimensional Mayhem on 23 May 2013
Security Questions: Differences between “Grant” and “With Grant?”
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer. Instead of just a re-cap of all of the questions, instead I’ve opted… Read more
0 comments, 85 reads
Posted in StrateSQL on 23 May 2013
I’m presenting at the PASS Summit!
I am fortunate enough to have been selected to give a presentation at the PASS Summit 2013 in Charlotte, NC on October 14-18. It’s amazing to think that, although I have been in IT for 25 years, I first started to build my brand when I started this blog only… Read more
0 comments, 102 reads
Posted in James Serra's Blog on 23 May 2013
Exploring Excel 2013 for BI Tip #7: Retaining Pivot Table Size After Data Refreshes
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not forget what… Read more
1 comments, 89 reads
Posted in DataOnWheels on 23 May 2013
Business Objects on Linux and SQL Server
This is just a quick post to share a lesson learned while I was on an engagement where the client’s reporting environment was using SAP Business Objects (BO)running on Linux for reporting. We were doing a test to move the underlying data warehouse from another database platform to SQL Server… Read more
0 comments, 84 reads
Posted in SQL Chicken on 23 May 2013
Dedicated Administrator Connection (DAC)
0 comments, 79 reads
Posted in SQL Server 365 on 23 May 2013
Starting with Azure
I’ve been meaning to do this, and I finally had the chance recently to start working with Azure. Red Gate is investing in cloud tools, and more development tools, so it’s something I need to work on.
I went to the Azure page, and noticed a “Member Offers” link.
When… Read more
0 comments, 133 reads
Posted in The Voice of the DBA on 23 May 2013
DR planning article up at MSSQLTips!
My latest article is up at MSSQLTips.com:
Disaster Recovery Planning for Microsoft SQL Server - Getting Backups and Restores Right
For more of my articles:
0 comments, 94 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 May 2013
Giving an SSIS security webinar with Andy Leonard
Andy Leonard (blog | twitter) and I are teaming up to do a security presentation on SSIS. It's scheduled for Wednesday, May 29th, at 11 AM EDT.
Register to attend the webinar!
We're going to look at the typical ETL (Extract, Transform, Load) pipeline and consider the weak points… Read more
0 comments, 190 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 May 2013
Ad-hoc Reporting with SharePoint Recording and Q&A
I hope you were able to attend my free webinar on Ad-hoc Reporting with SharePoint on May 21, 2013. If you weren’t you can now watch the recording here.
As usual there were many great questions that I wasn’t able to answer and I thought I’d follow up on… Read more
0 comments, 77 reads
Posted in Devin Knight on 23 May 2013
Speaking at SQL PASS Summit 2013
WOW! I was selected to present at the SQL PASS Summit 2013 in Charlotte, NC. in October! All I can do is keep repeating WOW. I’m in shock.
Even better, I was chosen for a spotlight session! I could not be more ecstatic! I received the email while I was… Read more
0 comments, 74 reads
Posted in Technobabble by Klee from @kleegeek on 23 May 2013



Subscribe to latest posts