|
|
|
|
Latest Blog Posts
-
|
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update #10 Build # 10.00.5840 KB Article: KB #2814783 6 fixes Relevant for builds 10.00.5500 -> 10.00.5839 NOT for SQL Server 2008 R2 (10.50.xxxx)...
|
-
|
I was so glad to hear today that Azure is expanding to Australia. This helps with two remaining areas of concern that I've heard from a variety of customers: Compliance and data sovereignty (not wanting to store data outside Australia) Latency (previously...
|
-
|
In March 2013 I launched an initiative called AdventureWorks on Azure in which I hosted the AdventureWorks2012 sample database on Azure so that the SQL Server community at large could use it to get familiar with what SQL Azure Windows Azure SQL Database...
|
-
|
I and Alberto Ferrari will moderate the following Birds of a Feather session at TechEd North America 2013 : CODE: BOF-ITP21 TITLE: How Far Can You Push Tabular? SPEAKER: A. Ferrari; M. Russo TIMESLOT: June 5, 2013 at 1:30 pm ROOM: 263 Abstract: Tabular...
|
-
|
My next guest is a person I have known for years, and have worked with on several occasions, Jason Strate ( @stratesql ). Jason is a very active writer and speaker (at my first SQL Saturday event, he spoke four times!), and always seems very busy. His...
|
-
|
Today at SQL Saturday #220 in Atlanta I presented a new brand new session , "SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headaches." This session is designed to help people quickly analyze query plans and find likely...
|
-
|
Red Gate rocks. If you didn’t know that already, you know it now. The latest evidence to support this claim is the publication of the schedule for US SQL in the City events. They are: 9 Oct – Pasadena 11 Oct – Atlanta 14 Oct – Charlotte Registration for...
|
-
|
When : October 15, 2013 8:45 am - 4:45 pm Charlotte, NC Where : Wake Forest University Charlotte Center 200 North College Street Charlotte, NC 28202 What : Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual...
|
-
|
I don’t know why but for some reason I have never liked using sp_spaceused. It probably started a long time ago when the results were often inaccurate due to the meta data being out of date. I am pretty sure that was fixed somewhere along the line but...
|
-
|
Matt Masson and I are co-presenting Developing Extensions for SSIS 22 May 2013 at 11:00 AM EDT. If you’ve never heard Matt present, you are in for a treat. Matt is knowledgeable (he helped build Integration Services 2012!) and entertaining. This is going...
|
-
|
Fellow MVP Alessandro Cardoso sent me information today about a private cloud and virtualisation event that's running later this month. It's being offered in Brisbane, Sydney, and Melbourne. If that's of interest, you'll find more details here: http://virtualisationandmanagement.wordpress.com/2013/05/08/private-cloud-virtualisation-strategy-events-in-brisbane-melbourne-sydney-may-and-june-2013...
|
-
|
Its been a couple of weeks since SQLBits XI happened in Nottingham and I thought I’d jot down a few thoughts for posterity. First the venue. I think its fair to say that the overall consensus was that the East Midlands Conference Centre was the best SQLBits...
|
-
|
Imagine that you're moving thousands or millions of rows between two tables . Maybe it's between a staging table and a data warehouse in an ETL process. Maybe you're manipulating some data via a temp table as you're preparing lookup data for your OLTP...
|
-
|
The topic for this month’s T-SQL Tuesday is about the journey. Wendy Pastrick’s choice (I’m hosting again next month!). There are a lot of journeys. There are some that just keep going, and others that seem to finish (some in success; some in failure)....
|
-
|
A week ago I gave my session on the subject. It is only first part of the two – second will be next time when there is an open slot. Demos from my session are available here ....
|
-
|
While I was on vacation last week in Scotland Simple Talk published a new article I wrote called Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets. Hope you have as much fun with it as I did writing it. Allen...
|
-
|
Hi Folks, On Thursday night, I got to record a podcast with Reza Rad. I was interested to speak to Reza after reading his SQL Server 2012 Integration Services Cookbook . In the show, we discuss SQL Server Integration Services (SSIS) extensibility and...
|
-
|
I will be on for speaking next week at SQL Saturday #220 #SQLSATATL. My sessions will be on SQL Server TDE and SMO Internals for High Performance PowerShell. Both are great fun to present and good information to have. Hope to see you there in Alpharetta,...
|
-
|
I generally do not get involved in high-end SAN systems. It is almost impossible to find meaningful information on the hardware architecture from the vendor. And it is just as impossible to get configuration information from the SAN admin. The high-end...
|
-
|
Let’s begin with an assertion: “People are more important than process.” – Andy, circa 2008 Whenever an enterprise or institution adopts a new process or policy, that policy should serve people and not shackle them. The nicest thing that can be said about...
|
-
|
I am super-excited to visit New Orleans next month for Microsoft TechEd; it will be my sixth time speaking at the show. My session takes an in-depth look at some of the techniques I've developed for using SQLCLR modules -- and some of the great performance...
|
-
|
“Case Studies” are a great tool when you’re evaluating a platform. Having evidence that other companies have deployed Windows Azure, in addition to how they did it, is a good way to plan your own deployments or even just evaluate whether...
|
-
|
SQL Server Dynamic Management Views (DMV's), or more appropriately termed Dynamic Management Objects (DMO’s), have been around for quite a while now. They made their first appearance in SQL Server 2005 and they unlocked a wealth of information that was...
|
-
|
In June I and Alberto will deliver a pre-conference seminar at both TechEd North America (New Orleans, LA) and TechEd Europe (Madrid, Spain). This day is a very good quickstart for those of you that still didn't complete one of our books , or those of...
|
-
|
Definitions Read-Uncommitted Isolation Level The read-uncommitted isolation level is the least restrictive isolation level within SQL Server, which is also what makes it popular for developers when looking to reduce blocking. Blocking is “typically” not...
|
|
|
|
|
|