|
|
|
|
Latest Blog Posts
-
|
John Sansom ( Blog | @SqlBrit ) is committed to sharing “what I believe it takes to be an outstanding Data Professional.” To that end, John shepherded a book project called DBA JumpStart . The concept of the (free!) e-book is: “If you could give a DBA...
|
-
|
More than one year ago, I and Alberto started recording videos for Project Botticelli, and now we have a set of videos about DAX that you can watch online. There are a few videos free, and others are available in the monthly subscription. If you are interested,...
|
-
|
Kevin Kline provides his top piece of advice for junior DBAs who are early in their career as a data professionals....
|
-
|
This is the fourth part of the fraud detection whitepaper. You can find the first part , the second part , and the third part in my previous blog posts about this topic. Data Mining Models We create multiple mining models by using different algorithms,...
|
-
|
Learn to program. It only takes an hour and it’s free. You can learn how to code at an Apple store on December 11, 2014 or the entire week at a Microsoft retail store. Learn more about this project here . Do you already know how to code? Teach someone...
|
-
|
“It just runs slow these days” I’m sure you’ve heard this, or even said it, about a computer that’s a few years old. We remember the days when the computer was new, and it seemed to just fly – but that was then, and this is now. Change happens, things...
|
-
|
If your machine doesn’t have a DVD drive, you’ll either need to do a network boot or boot from USB. Fortunately making bootable USB media from an iso file is much easier. Microsoft has a free utility shown below that does it painlessly. When installing...
|
-
|
Let me point out the upcoming live events scheduled for December 2013 organized by PASS Business Intelligence Virtual Chapter . Create and Load a Staging Environment from Scratch in an Hour with Biml Date: Thursday 12 December Noon PST / 3 PM EST / 8...
|
-
|
I love me a good keyboard shortcut and there’s some I would like to use in Excel all the time if only I could darn well remember them. CTRL+ Spacebar Select the entire column containing the currently selected cell(s) Shift + Spacebar Select the entire...
|
-
|
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...
|
|
|
|
|
|