|
|
|
|
Latest Blog Posts
-
|
Alberto Ferrari wrote an interesting article about DIVIDE performance in DAX. This new function has been introduced in SQL Server Analysis Services 2012 SP1, so it is available also in Excel 2013 (which still doesn’t have other features/fixes introduced...
|
-
|
The SQL Server team has released SQL Server 2012 SP2 Cumulative Update #1. This cumulative updates Service Pack 2 to include the fixes from SP1 CU#10 and a few from CU#11, including the fix for the online index rebuild corruption issue I discussed recently...
|
-
|
I've created two simple, yet very useful, script to extract some useful data to quickly monitor SSIS packages execution in SQL Server 2012 and after. get-ssis-execution-status get-ssis-data-pumped-row s I've started to use gist since it comes very handy,...
|
-
|
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #11. This cumulative update includes a fix for the online index rebuild corruption issue I discussed recently on SQLPerformance.com . KB Article: KB #2975396 Build # is 11.0.3449 Currently...
|
-
|
Back home from SQLBits XII , back to normal life. However, I am already missing the conference. I have spoken with quite a few other speakers, and our conclusion is, as my friend Niko Neugebauer said: this conference is simply second to none. Great content,...
|
-
|
The database I inherited when I started my current job sends out lots of mails. It does so using Database Mail, and it has lots of mail accounts and mail profiles defined. I know that several of those profiles are used, I suspect that some are not, and...
|
-
|
As database professionals, I find that one simple thing unites us in our mission, above all else: we absolutely hate long running things . I'm with you. I'm here for you. I want to help you reject long running things . PASS Summit 2014 , the premier SQL...
|
-
|
There's a lot of discussion about the process of bringing new speakers to a level that allows them to be ready and able to present at major conferences like the PASS Summit . Andy Warren (@sqlandy) wrote a blog post about a speaker challenge and Brent...
|
-
|
An interesting experience with Office Click-to-Run is that trusting it to install updates the night before a conference where you are a speaker. I’m writing this blog post while Alberto Ferrari is delivering its part of the preconference training day...
|
-
|
So I have blogged about it, and I have prepared for it, and next Friday at lunch time I will be unveiling my new presentation. The location/other details can be found here: http://nashville.sqlpass.org/Home.aspx , but the abstract is: How In-Memory Database...
|
-
|
Using decimal numbers in Power Pivot and Tabular might produce small rounding differences in certain calculations. This is nothing new when you work with floating point, as many programmer knows. The implementation of RANKX might suffer of a behavior...
|
-
|
"WOW. That's exactly the feedback I would have loved to have for ALL my proposals in the past year. And not only for PASS Summit". No more and no less this is what I thought after having received the mail with all the feedback from the review committee...
|
-
|
I am finishing my plan for conferences in the 2nd half of 2014. I think I will speak in most of them. Here is my list. 1. SQLBits 2014 , July 17th-19th: high time to register, pre-conf seminars start in two days. I have an interesting pre-con seminar...
|
-
|
This is more for my own reference than anything else but today I was needing to enter a backslash key while using a US keyboard but with UK keyboard settings. After trying pretty much every key on the keyboard in all combinations, I realised there was...
|
-
|
Last week, Adam posted the feedback he received from PASS on the abstracts he had submitted for the PASS Summit 2014 . I was very happy he did – not only because the post itself was a good read, but also because I had not seen the PASS announcement on...
|
-
|
I'm really happy to be able to announce that I'll be delivering one full-day workshop and a regular session at PASS Summit 2014. Here's the titles and the short summary of my workshop and session: Agile Data Warehousing: from Start to Finish Full-Day...
|
-
|
One of the projects I have been working on as time permits is to construct a way to create a shared access signature using native T-SQL. Shared access signatures are needed when working with SQL Server data files in Azure. Mostly, DBAs would use a programmatic...
|
-
|
BACKUP TO URL was introduced as an add-on in Cumulative Update 2 for SQL Server 2012 Service Pack 1 and as a built-in feature for SQL Server 2014. I previously described this in a blog post . We have been using this in a variety of ways from on-premises...
|
-
|
Sessions of the event 24 Hours of PASS: SQL Server 2014 (which was held on last June at 25th and 26th) were recorded and now they are available for online streaming! If you have missed one session (in particular) or the entire live event, you can view...
|
-
|
This month's T-SQL Tuesday is about assumptions in SQL Server. Over on our new consolidated team blog at SQL Sentry , I discuss the following assumptions I come across with relative frequency: Case will always short circuit A seek is better than a scan,...
|
-
|
There is no equivalent to the SSIS Lookup transformation in T-SQL – but there is a workaround if you’re careful. The big issue that you face is about the number of rows that you connect to in the Lookup. SQL Books Online (BOL) says: If there is no matching...
|
-
|
During the last months I’ve seen an increasing adoption of Analysis Services Tabular (and I’m writing a longer article about a particular area of adoption which was probably not expected – more on that in a few weeks). This year at PASS Summit 2014 there...
|
-
|
This topic is titled to specifically consider only row estimation after joins, precluding discussion of row estimates at the source table, which has already been addressed in papers covering the new Cardinality Estimator in SQL Server 2014 and other statistics...
|
-
|
This part is part of an ongoing series of blogs I am writing while preparing to give a presentation based on the prefix of this blog's title. It is a work in progress as I explore the effects of the new in-memory model. I would love comments that tell...
|
-
|
Earlier I had commented on the TPC-H results published in April of this year for SQL Server 2014 using clustered column store storage, noting that two of the 22 TPC-H queries did not perform well in column store. I had speculated on the reason without...
|
|
|
|
|
|