|
|
|
|
Latest Blog Posts
-
|
I’ve been playing with PowerQuery in the last days and I’ve come across the need of accessing “parent” object data when using the ExpandTableColumn function. The solution is more tricky then one could imagine and I have to say a BIG “THANK YOU” to Miguel...
|
-
|
As we have just discussed, READ COMMITTED isolation level behaves very much like Sql Server's READ_COMMITTED_SNAPSHOT. As such, we need to be very careful with data integrity - lots of code that just works on Sql Server under its default isolation level,...
|
-
|
Kevin Kline and Richard Campbell, the host of RunAsRadio, discuss many of the new features in SQL Server 2014, plus the NoSQL movement, BigData, and how the roles of developers and databases continue to evolve in organizations today....
|
-
|
I ordered a 512 GB SSD so that I can get great performance running Windows 8.1. I’ll have all of my spinning drives intact, so I’m not worried about actual data loss. The concern is in preserving things like IE favorites for every family member. The User...
|
-
|
SQL Server 2014 introduces updateable nonclustered and clustered columnstore indexes. When new data is inserted, it goes first to deltastore where background process divides it into row groups, indexes and compresses. Indexing progress can be observed...
|
-
|
Software changes, new versions not only add new features, they also change internal behavior of old features, and not all the changes are documented! And how often, after a software upgrade, do you go through and test everything you knew was true, to...
|
-
|
Because of multi-valued concurrency control aka MVCC, there are many differences in queries' behavior with different isolation levels. Before running examples, let us set up test data. Setting up test data The following script sets up the data we shall...
|
-
|
This is the third part of the fraud detection whitepaper. You can find the first part and the second part in my previous blog posts about this topic. Data Preparation The problem of credit card fraud detection is not trivial. With every transaction processed,...
|
-
|
PostgreSql has simple and consistent error handling, which can be roughly explained in Sql Server terms as follows: XACT_ABORT is Always ON. In other words, error handling in PostgreSql has substantially less features, but it does have all the features...
|
-
|
As always, there are also some limitations for the SQL Saturday #274 Slovenia event. We have limited space in the classrooms, and can cover only a limited number of lunch meals. Therefore, if you plan to attend, you should register very soon. We are positively...
|
-
|
Transactions and error handling in PostgreSql are substantially different. We shall discuss only the features that we needed to learn to complete our project. It will take us more than one post to describe them all. TL;DR; Transactions and error handling...
|
-
|
UPDATE...FROM command on PostgreSql may raise no errors, but produce completely different results. Later I shall provide a repro, but first let us briefly refresh how UPDATE...FROM works on Sql Server. UPDATE...FROM on SQL Server ignores ambiguity We...
|
-
|
One of my biggest laments about being a SQL Server developer is that the tools provided by Microsoft to do our thang compare woefully to the feature rich, (largely) bug-free, “it-just-works” impression that one gets from seeing the tools available to...
|
-
|
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update #14 Build # 10.00.5848 KB Article: KB #2893410 6 fixes Relevant for builds 10.00.5500 -> 10.00.5847 NOT for SQL Server 2008 R2 (10.50.xxxx)...
|
-
|
In the sessions that I was attending in Redmond yesterday, I was interested to see the presenter discussing the idea of having individual database files in the cloud as some sort of bizarre option that’s now available in SQL Server 2014. I don’t see it...
|
-
|
All SQL Server queries using TOP and/or APPLY need to be changed - PostgreSql uses completely different syntax. Replacing TOP with LIMIT The following script shows how to do that: CREATE TEMP TABLE Runs ( State_Code VARCHAR , Run_Date DATE , Distance...
|
-
|
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #7. KB Article: KB #2894115 Build # is 11.0.3393 Currently there are 47 fixes (plus three undisclosed issues resolved); the most interesting to me are: KB #2879373 - FIX: Threads are...
|
-
|
- I have a challenging SQL problem for you, – yelled one of my coworkers one morning entering my office and dropping on his way a few pictures, SQL server system views map and a visitors chair. – Much more interesting than all your alerts and twitter...
|
-
|
This is a picture of my son, Stevie Ray, learning SQL on my Surface Pro 2. I bought the Surface Pro 2 the day it was released. I didn’t pre-order it because I wanted to read what others had to say about it first. I’m an early-adopter, but not the earliest...
|
-
|
Constraints in PostgreSql are implemented somewhat differently. To use them efficiently, there are quite a few details we need to be aware of. NULLs and uniqueness In PostgreSql, unique constraints allow multiple NULLs. This behavior is ANSI standard....
|
-
|
Correction: here is the final schedule for the SQL Saturday #274 Slovenia event! (OK, if some of the speakers does not cancel the presentation) DBA DEV BI 08:30 – 09:00 Registration 09:00 – 09:15 Lah, Prajdi č, Sarka: Keynote 09:15 – 09:30 Break...
|
-
|
The Azure team keep rolling out improvements at an amazing pace. Scott Guthrie posted recently about the latest set of changes. Here are the ones that I think are most important for SQL people: Import/Export Hard Drives Even though Azure storage accounts...
|
-
|
It’s easy to find what calls a stored procedure in SQL Server. Finding where it is called outside of SQL Server is an entirely different matter. I use great free utilities for either use case. Of course, you can use built-in features in SSMS to find out...
|
-
|
Hi Folks, If you want to get your head around the core improvements coming in the SQL Server 2014 wave, I'm presenting a Technet Live session on November 29th (Australian time). Registration is here: https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032570709&Culture=en-AU&community=0...
|
-
|
I had the distinct honour (honor) this week of recording a new SQL Down Under podcast with Dr David DeWitt from the Jim Gray Systems Lab at Microsoft. Anyone that has been to a PASS summit over the last few years would know that David seems to have single-handedly...
|
|
|
|
|
|