|
|
|
|
Latest Blog Posts
-
|
Last week Microsoft released a preview of the next version of Azure SQL Database, which is available now in a preview version. The feature set is nearly complete when compared to the standalone version of SQL Server 2014 and a clustered index on every...
|
-
|
Microsoft has released Cumulative Update #5 for SQL Server 2014. KB Article: KB #3011055 56 fixes total (47 fixes listed publicly at time of publication). Build number is 12.0.2456 Relevant for @@VERSION 12.0.2000 through 12.0.2455...
|
-
|
A question came up from a developer yesterday. He could see how to set a transaction isolation level but didn’t know how to determine the current transaction isolation level. That detail is available in the sys.dm_exec_sessions DMV. Here’s an example:...
|
-
|
A feature that many people require in SSAS Tabular is the ability to refactor existing names, doing a correspondent rename in all existing objects in the model. I agree that this is an important feature that should be added in the development environment,...
|
-
|
So the event is over. I think I can say for all three organizers, Mladen Prajdić , Matija Lah , and me , that we are tired now. However, we are extremely satisfied. It was a great event. First few numbers and comparison with SQL Saturday #274 , the first...
|
-
|
I spend a lot of time working with software houses, helping them to make their applications work well with SQL Server. One thing that I’ve heard loud and clear over the years is that most software houses won’t write a single line of code that will only...
|
-
|
We’ve been so excited having local data centres for Microsoft Azure. The one disappointment has been that Office 365/Power BI has still been based out of Singapore data centres. That has an effect on people that worry about data sovereignty and it also...
|
-
|
Lately I’ve been using Azure Automation which is a service on Azure for running Powershell Workflow scripts, as such as I’ve diving deep into Powershell Workflow. What’s Powershell Workflow? I’m glad you asked: A workflow is a sequence of programmed,...
|
-
|
In Australia, almost certainly yes. Australia recently saw two Azure data centres open, meaning that customers can now consider hosting data in Azure without worrying about it going overseas. Whether you’re considering SQL Database or having an Azure...
|
-
|
Learning to write DAX queries is important in the new world of tabular data models. DAX Studio is the best environment right now for learning to write and test DAX queries. Today Darren Gosbell announced on his blog that version 2.0 of DAX Studio is out...
|
-
|
Darren Gosbell announced on his blog that DAX Studio 2.0 is available. This new release has a completely new user interface, a renewed architecture and also work as a standalone executable without Excel. Yes, you read it right. You can use DAX Studio...
|
-
|
I’ve ended up with a number of Microsoft figurines over the years. It all started with Nine Guy, then went on to the whole Source Force team: It’s been interesting to see how they’ve evolved over the years. Here are the SQL Server ones: SQL Server 2005...
|
-
|
If you work with SQL Server (or want to work with SQL Server), this is a good time of the year to think about your career. Why? It’s the holiday season and you should have some time off… unless you have a Crappy Job . You can use some of this time to...
|
-
|
This weekend on December 6, 2014 I continue my evangelization of Columnstore—possibly the most exciting unheralded feature in SQL Server 2014—at SQL Saturday 347 at an auspicious venue: the Microsoft Technology Center in Chevy Chase, proximal...
|
-
|
This is a white paper that I put together recently about APS / PDW Query Optimisation. You may have seen it at http://blogs.technet.com/b/dataplatforminsider/archive/2014/11/14/aps-best-practice-how-to-optimize-query-performance-by-minimizing-data-movement.aspx...
|
-
|
Lately I have been working with a database that has a comprehensive table partitioning requirement. In order to do troubleshooting, and to test partition switching and data archiving code, we needed a quick but accurate way to view what rows are in which...
|
-
|
I have been working with a customer that has an existing database for a home-grown application, and like many databases it’s had various tuning efforts over a period of time. Those were not necessarily coordinated, which resulted in indexes with some...
|
-
|
When using BIML within BIDS Helper , if your BIML Script files get complex it may be quite hard to debug BIML Script Execution in order to understand what’s going on behind the scenes. On Windows Server 2008 it was possible to use the System.Diagnostic.Debug.WriteLine...
|
-
|
Microsoft released SQL Server Data Tools (SSDT) along with SQL Server 2012 in the Spring of 2012. Since then I’ve noticed an upward tick in both the number of organisations that are using SSDT and the number of questions that are getting asked about it...
|
-
|
I apologize to all you folks who attended my Hekaton precon at the SQLPASS Summit last month, who have been eagerly awaiting my answers to some of the unanswered questions. I had got most of the answers sorted out, but I was waiting for one last reply,...
|
|
|
|
|
|