|
|
|
|
Latest Blog Posts
-
|
I published an article describing how to implement the grouping of sales transactions by age of customer at the moment of the transaction by using PowerPivot or Analysis Services. The same pattern can be used also for any kind of banding operation, this...
|
-
|
On Friday, May 10 I will be speaking for the Knoxville SQL Server User Group, and on May 18, I will be speaking at SQL Saturday in Atlanta. Both days, my session is my old chestnut “Database Design Fundamentals”. It is my favorite session to do because...
|
-
|
Yesterday I gave my session to the fine folks in Nottingham, UK. Below is a zip file containing the deck and samples: Bertrand_BitsXI_BadHabits.zip...
|
-
|
I'm so happy that DAX Studio finally supports Excel 2013! As Darren Gosbell described in his blog , this release has a few internal changes that will better support future enhancements. I will port the code to capture the query plan for a query in this...
|
-
|
In his article Healthcare's Big Problem With Little Data , author Dan Munro raises salient points about the state of health-related data. Electronic Health Records (EHR) were promoted as the end-all-be-all solution for the industry – a standardization...
|
-
|
Cloud computing is actually being largely driven by the “Consumerization of IT”. That phrase, as grammatically incorrect as it is, represents a fundamental change to the way businesses think about technology, and subsequently how the IT team...
|
-
|
Microsoft released the Workbook Size Optimizer for Excel , the first version of an Excel add-in for Excel 2013 that inspects the data model and suggest possible optimizations. Fundamentally, it tries to apply the best practices descripted in a white paper...
|
-
|
Today, I would like to give you a primer on how to read the benchmark reports that are published by the major database and hardware vendors....
|
-
|
The BETWEEN operator is a handy SQL construct, but it can cause unexpected results when it isn’t understood. Consider the following code snippet: where x between .9 and 1.10 One of the questions you should ask is this: What is x? What if x has a float,...
|
-
|
Back in late 2011 to early 2012, I was asked to look into issues for a SQL Server system supporting kCura Relativity. Relativity is an e-discovery platform, that is, a document search management system frequently used for document discovery is legal cases....
|
-
|
Regular readers of my blog might have realised that I am a huge advocate of subscribable calendars and the data format that underpins them – iCalendar . On 8th Feb 2012 I wrote a blog post entitled SQLBits now publishing all SQLBits agendas as an iCalendar...
|
-
|
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...
|
|
|
|
|
|