|
|
|
|
Latest Blog Posts
-
|
The SQL Server team has released CU #7 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2823247 Build # is 11.0.2405 This build has 17 fixes Relevant for builds 11.0.2100 -> 11.0.2404. Do not attempt to install on SQL Server 2012...
|
-
|
On April 23 I will present DAX in Action in London and Cardiff at SQLLunch event. How is it possible I will be in two places at the same time? This will be a remote presentation delivered in two locations, where you can have lunch while watching the session....
|
-
|
I didn’t travel to the SQL Pass Business Analytics conference this week but I keenly followed what was going on via the #passbac hashtag on Twitter. Seemingly the big announcement was Geoflow Preview for Excel 2013, an add-in for Excel that visualises...
|
-
|
Hear about the latest announcements at the PASS Business Analytics Conference and from the renown keynote speaker and author of "Freakonomics", Dr. Steven Levitt....
|
-
|
I’m excited to be offering a beginning PowerShell session at SQL Saturday #211 in Chicago on Saturday, April 13. This time we’re making it a family weekend, bringing our two boys. I haven’t been to Chicago for many years, and it’s, of course, an Architecture...
|
-
|
I gave two talks at the SQL Intersection conference this week in Las Vegas. One was my Bad Habits & Best Practices session, and the other is a new one discussing advantages to upgrading to SQL Server 2012 even if you're not using Enterprise Edition....
|
-
|
The PASS Business Analytics Conference starts today in Chicago. In the next two days, there will be two keynotes . The most famous Steven Levitt, author of Freakonomics, will be on stage on Friday, and tomorrow (Thursday) we will see Kamal Hathi and Amir...
|
-
|
I just started using a new DMV (one that’s actually an ‘F’ not a ‘V’, as in Function) that gives us more info about distribution statistics. It returns info about the last statistics update date (which is also available with a function STATS_DATE())....
|
-
|
f you want to know more about Windows Azure, how it works, the components, or more about the entire platform, I’ve written about that here: http://blogs.msdn.com/b/buckwoody/archive/2012/06/13/windows-azure-write-run-or-use-software.aspx But…....
|
-
|
For this T-SQL Tuesday Bob Pusateri asked us to share how we came to love presenting. Before I ever got involved in computing technology I had (and still have) a love for the theatre, specifically musical theatre. When I was little the majority of albums...
|
-
|
I am honored to present Creating a Custom SSIS Task this Saturday – 13 Apr 2013 – at SQL Saturday 189 – Costa Rica ! Espero que se unan a mí! :{>...
|
-
|
I recently stumbled across a nuance of the SSIS expression language which, when you think about, kinda make sense – but it does help to be aware of it. Its concerned with casting of datetime values using the SSIS expression language Take the following...
|
-
|
I posted the other day about a hotfix that's needed after you apply SQL Server 2012 SP1 CU3, to still be able to open or edit SSIS projects or database maintenance plans in SSDT. However, I found that after I applied CU3 and the hotfix, that all my stored...
|
-
|
Louis Davidson just asked me why I write , and now Bob Pusateri ( @sqlbob ) is asking me why I present , which is his question for this month’s T-SQL Tuesday. If you didn’t follow the link to see his actual question, you’ll need to know that he actually...
|
-
|
It's great to see the constant roll-out of capabilities across the Azure platform. One in particular that many have been waiting for is Active Directory. Scott Guthrie posted today that it's now available for production use. This is particularly significant...
|
-
|
In the third entry in this series, we take a turn south, not in quality, but in the geography of our next entrant. Rather our interview target is Rob Farley, who is from (well lives in) Australia. Rob Farley is a SQL Server MVP, and is quite a busy...
|
-
|
The Hyper Threading technology returned to the Intel Xeon (and Core-ix) with processor codename Nehalem in 2009. It was first introduced with Willamette in late 2000?, and the first Xeon in 2001. But the Core 2 architecture, 2006, in the Xeon 5300 and...
|
-
|
One of the common objections that comes up when talking to people about storing their data in Azure, is that "we are not allowed to do it". In so many cases, that simply isn't true, or it's true for a small part of the overall data. In other cases, it's...
|
-
|
Just over 12 months ago I published a blog post entitled AdventureWorks2012 now available for all on SQL Azure . In it I explained that I had set up a Windows Azure SQL Database (then known as SQL Azure database) for the SQL Server community to use and...
|
-
|
Cumulative Update 3 for SP1 for SQL Server 2012 caused a number of problems with SSIS packages. This also applies to database maintenance plans as they are also SSIS packages. After applying the update, you could get this error when opening an SSIS package:...
|
-
|
That’s right, I have two free licenses for Red Gate’s SQL Source Control for Oracle that are burning a hole in my virtual pocket! I like Red Gate’s SQL Source Control for SQL Server a lot. At Linchpin People , we are using SQL Source Control for several...
|
-
|
Kent Bradshaw and I have been loading medical data for years. We worked together at Unisys and Molina Medicaid Solutions to build Extract, Transform, and Load (ETL) solutions for state Medicaid administrations in the US. We decided to share some of our...
|
-
|
The Database Lifecycle Management is an MSDN curated content view providing a single location to find many of the best solutions for common customer tasks in Microsoft SSDT, SSMS, and SQL Database....
|
-
|
In the same way that a map is a natural choice for displaying data with a geography element to it I’ve long opined that a calendar is a natural choice for displaying data with a time element to it, my main output on this topic is at Thinking differently...
|
-
|
One of the nice things about doing user group presentations is that when you’re putting the presentation together you invariably learn about features that were previously unbeknown to you; so it proved as I stumbled upon SSDT’s database drift detection...
|
|
|
|
|
|