|
|
|
|
Latest Blog Posts
-
|
It’s been just over a week since Windows Azure announced the GA of Infrastructure Services , marking the beginning of a fully supported Infrastructure as a Service in Windows Azure, with SQL Server as a major component. Pre-installed SQL Server...
|
-
|
My next guest is Doug Lane , who has been blogging for the past few years on his website: http://www.douglane.net/ . Doug is also a speaker who has spoken at SQL Saturdays as well as the SQL PASS Summit , and as I write these interview questions was on...
|
-
|
Five Things I’ve Learned About Surviving the Telecommute Over the past several years my wife and I went through this strange series of events where we swapped work roles – first she worked remotely for a Minnesota company, from our home in Seattle, and...
|
-
|
SQL Server Data Tools (SSDT) has a neat feature where you can add snippets into your scripts via the right-click context menu: I’m finding it very useful indeed. The same feature exists in SQL Server Management Studio (SSMS) as well by the way: One thing...
|
-
|
Let's talk about database application benchmarking. This is a skill set which, in my opinion, is one of the major differentiators between a journeyman-level DBA and a true master of the trade. In this article published in my monthly column at Database...
|
-
|
One year after the release of SQL Server 2012 I see the growing demand for DAX. There are two reasons for that: an higher number of PowerPivot users started to build more complex data models, and SSAS Tabular is starting to be adopted by a larger number...
|
-
|
During a PowerPivot Workshop course we received an interesting question from a student: “Can I use LASTNONBLANK (and FIRSTNONBLANK) with a column which is not a date column?” The reason is that we introduce LASTNONBLANK in the Advanced Time Intelligence...
|
-
|
I'm really impressed by the rate that the Azure team is making and releasing enhancements. Scott Guthrie posted about these again recently. The following items in the announcement were ones that I think can be useful to those with an interest in SQL Server:...
|
-
|
Many of us have probably seen recent headlines titled Excel Error - major catastrophe, end of the world blah blah blah. No where in any of these is it cited that there was actually an error made by Excel. But if there was a mistake, people would rather...
|
-
|
Join SQL Server MVP Tim Mitchell ( blog | @Tim_Mitchell ) and I as we demonstrate and discuss the many uses of scripting in SQL Server 2012 Integration Services 8 May 2013 at 11:00 AM EDT! In this demo-packed session, two co-authors of the book SSIS Design...
|
-
|
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....
|
|
|
|
|
|