|
|
|
|
Latest Blog Posts
-
|
Windows Azure has added Infrastructure-as-a-Service (IaaS), the ability to deploy, run and manage Virtual Machines, to its growing list of services . You can create Virtual Machines from a gallery, upload them from images you create locally on Hyper-V...
|
-
|
Earlier today I posted the following question on Twitter: Foreign keys in a data warehouse. Yes or no? This discussion is looming at work, i know my position but am interested in what others think. ( https://twitter.com/jamiet/status/324215986729385986...
|
-
|
Kent Bradshaw and I are pleased to announce another free webinar: Medical Data Integration with SSIS 2012, Part 2 - Providers and Drugs. Register today! The recording of the first part of this series is available here . :{>...
|
-
|
Today Microsoft released new cumulative updates for SQL Server 2008 R2. SQL Server 2008 R2 Service Pack 1 Cumulative Update # 12 KB Article: KB #2828727 7 fixes listed at time of publication Build number is 10.50.2874 Relevant for @@VERSION 10.50.2500...
|
-
|
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...
|
|
|
|
|
|