|
|
|
|
Latest Blog Posts
-
|
This is the fourth blog post in the series dedicated to the Tips and Tricks of DML Triggers development. The previous parts can be found here: SQL Server DML Triggers - Tips & Tricks - Part 1 ("Intro" & "Triggers activation order") SQL Server...
|
-
|
I have been recently asked if Always On supports metadata operations on tables. The operation is add, drop and column rename. I said that it was possible. However I was informed that during column rename there was an error about “ replication”: Caution:...
|
-
|
Even with the right indexes in place, spatial queries in SQL Server are often too slow – but they needn’t be. Two of the most commonly found patterns of query in the spatial world are when you’re looking for the nearest thing to where you are (which I’ve...
|
-
|
Today I was asked to do a pretty easy thing. The task was to add a filestream support to a table that already stores some documents. The customer wants to keep the data outside the database because he uses the SQL Server 2014 Express edition. According...
|
-
|
A few years ago at a conference, a young man approached me and asked if I was ready for my presentation. I squared with him (for emphasis) and replied, “No, sir. In fact, I’m worried about it.” He looked a little stunned and said, “Why?” “I’ve never done...
|
-
|
Microsoft has released Cumulative Update #7 for SQL Server 2014. See this blog post for more information. KB Article: KB #3046038 41 fixes listed publicly at time of publication (47 total) Build number is 12.0.2495 Relevant for @@VERSION 12.0.2000 through...
|
-
|
In my class in Budapest last week, someone asked if point-in-time recovery was supported for transactions on memory-optimized tables. I couldn’t think of a reason why not, but I had never tried it. And just because there is not a technical inhibitor to...
|
-
|
Back in Feb, I went on a diatribe-rant against the standard SAN Vendor configuration practice. The Problem with Standard SAN Configuration IO Performance , article and accompanying post , showed IO performance metrics for a batch driven transaction processing...
|
-
|
If you are tired today maybe you could take your time and spend the whole weekend with the SQL Server 2014 and Azure? The new MVA course is ready :) and waiting for you. Just visit the link http://bit.ly/1CXZT90 and enjoy. Watch out - it's in Polish :)...
|
-
|
I find many of the MVA courses great for quickly getting across concepts or areas that I haven’t worked with before. This month, the local MVP program has asked me to highlight the following MVA courses. The first two in particular look useful for SQL...
|
-
|
Hierarchical clustering could be very useful because it is easy to see the optimal number of clusters in a dendrogram and because the dendrogram visualizes the clusters and the process of building of that clusters. However, hierarchical methods don’t...
|
-
|
Stop me if you've heard this one before . Microsoft has released Service Pack 1 for SQL Server 2014. However, do not install it if you use the SSIS catalog (SSISDB) . From the Release Services team blog : Notice: The SQL SSIS team has found an issue with...
|
-
|
Do you remember that time kindness backfired? Do you remember kindness letting you down? Me neither. Kindness never fails. I can hear you thinking, “Yeah, Andy? Well there was this time I was kind and…” The thing you’re going to finish that sentence with,...
|
-
|
Master Data Services till recently didn’t have a supported way to clean the transaction logs, validation issues history and Staging tables. For a MDS system with lot of data changes and ETL processes over the period these tables can grow exponentially...
|
-
|
Hi Folks, we’ve been working hard on a new Azure Machine Learning course. Come and spend a solid day finding out why Azure Machine Learning should be part of your arsenal. Our first Melbourne offering of Azure Machine Learning Core Skills is 31st July....
|
-
|
To view a query plan, you need SHOWPLAN permission on the database level at least. You have this if you have CONTROL DATABASE, or CONTROL SERVER, or if you have ALTER TRACE at the instance level. I know this last one because it’s mentioned in Books Online...
|
-
|
Have you looked into Azure Machine Learning as yet? If not, this might help. It’s a free eBook on getting started with it. Click the book to follow the link:...
|
-
|
Microsoft has recently presented the cloud platform: Azure Machine Learning . Azure Machine Learning provides an easy-to-use and powerful set of cloud-based data transformation and machine learning tools. If you want to know more, you can download, for...
|
-
|
I've received a number of requests over the past couple of years for an Azure-specific version of sp_whoisactive . Given the combination of a lack of interesting DMVs available in Azure and my general lack of interest in all things Azure related, creating...
|
-
|
Was speaking with a customer today about an issue where they were receiving “Out of Memory” exceptions when trying to load a 32 bit PostgreSQL ODBC driver from within an SSIS package. When the package was run from the command line using Dtexec, all was...
|
|
|
|
|
|