|
|
|
|
Latest Blog Posts
-
|
Either SQL Server Management Studio (SSMS) or Visual Studio can be used for database development. I put them side by side into a single composite screen capture where you literally see the gaps between the products. SQL Server 2012 was installed with...
|
-
|
This week a SharePoint conference took place somewhere and I took more than a passing interest because it clearly wasn't a SharePoint conference, it was a Office365/Yammer conference and as far as I can discern the big takeaways were: SharePoint Social...
|
-
|
Never? You are not alone. None of the maintenance solutions I use includes functionality to rebuild a heap, and that includes Maintanance Plans and Ola Hallengren's maintenance solution. "So why would you want to rebuild a heap, when it isn't sorted in...
|
-
|
A few days ago I published the article FILTER vs CALCULATETABLE: optimization using cardinality estimation , where I try to explain why the sentence “CALCULATETABLE is better than FILTER” is not always true. In reality, CALCULATETABLE internally might...
|
-
|
If there is one server setting that is close to universal to configure, then it is probably the "max server memory" setting. The setting is documented here . There are plenty of articles out there on this subject. The purpose for this article is for me...
|
-
|
Regular expressions can easily and quickly remove trailing spaces from every line in your query window as well as a few other tasks I’ll explain. To get started, you need to know how to specify the end of a line. There are two ways to specify the end...
|
-
|
The commands SET STATISTICS TIME ON SET STATISTICS IO ON return information about query executions and are very useful when doing performance tuning work as they inform how long a query took to execute and the amount of IO activity that occurred as a...
|
-
|
Database Mail has a couple of log tables in the msdb database. These can become large over time. I've seen MSDB databases over 1 GB in size, where normal size is less than 50 MB (heavy usage of old SSIS deployment model excluded). Unfortunately Maintenance...
|
-
|
It is available the new edition of the advanced OLAP book, now called “ Expert Cube Development with SSAS Multidimensional Models ”. The previous edition was titled “Expert Cube Development with Microsoft SQL Server 2008 Analysis Services” and the biggest...
|
-
|
Ever wonder which specific T-SQL pattern is best for splitting strings? There are lots of ways to calculate running totals, but which is optimal? What CPUs are best for SQL Server 2012? For SQL Server 2014? Find out more in this post from Kevin Kline...
|
-
|
Today is my least favorite part of the whole speaking thing. It is the day that I put myself out there and wait to see if I get rejected or accepted. Rejection stinks, but at the same time, being accepted means more work. Neither are perfect, and as I...
|
-
|
There are two ways to test how your queries behave on huge amounts of data. The simple option is to actually use them on huge amounts of data – but where do you get that if you have no access to the production database, and how do you store it if you...
|
-
|
SQL Server performance has the interesting nature in that no matter how sound and logical an idea is on how it might behave in one scenario compared to another, what actually happens could be very different. Presumably the reason is that what happens...
|
-
|
When you visit websites, you may or may not have noticed the small icons that appear in the title bar areas. These are called Favicons. Here’s an example of one in Chrome: In Internet Explorer, they appear in several places: They...
|
-
|
I’ve always thought that the support for spatial data types that was added in SQL Server 2008 was one of the best parts of that release. In SQL Server 2012, a great set of enhancements were made to the spatial support. We’ve had lots of interest lately...
|
-
|
Apparently you cannot pass an argument to a DAX measure. In reality, you can interact with a slicer that has the only purpose of representing a parameter used by a DAX formula. You just create a table in the Power Pivot or Tabular data model, without...
|
-
|
Well, it has been over a year since my last insanely optimistic blog about the next year , but this year it is going to be (actually) different (not like the last time I said it would be different) Usually, like pretty much everyone on earth, I overestimate...
|
-
|
My latest article in the Stairway to Integration Services , Flexible Source Locations - Level 16 of the Stairway to Integration Services is now live at SQL Server Central ! Enjoy! :{>...
|
-
|
Many people requested me how to connect to Power Pivot from an external program, without publishing the workbook on SharePoint or on Analysis Services Tabular. I always said it is not possible (for both technical and licensing reasons), but someone observed...
|
-
|
In its first two months, DAX Formatter served 3,500 requests and I see the daily trend slowly raising. If you have observed carefully the first articles published on DAX Patterns, you might have seen that you can click the link”Code beautified with DAX...
|
-
|
Accepted wisdom when one purchases an app from a business store is that one gets free updates for life. This is, quite obviously, an unsustainable business model and I suspect is the main reason why so many apps use advertising to generate income. There...
|
-
|
The session Troubleshooting Clusters by Allan Hirt ( @SQLHA ) has been published on channel SQLPASS TV . Abstract Whether you are new to clusters or have years of experience, you may still cross your fingers when implementing a failover cluster instance...
|
-
|
Why wouldn’t you make a nice trip in Central Europe? Besides spending some nice days in beautiful cities, you have also a business-type excuse for the trip. You can join the two SQL Saturday events. The first one is going to take place in Budapest, March...
|
-
|
I hear comments from people all the time that say it’s not worth posting details on the Connect website as they don’t get actioned anyway. While it can seem a frustrating process, and often take quite a while, improvements do come from there. At a SQL...
|
-
|
Creating Distinct Count calculations in DAX is pretty easy when the target of the operation is a column in the “fact table” of a star schema. When you want to apply the DISTINCTCOUNT function to a dimension attribute (such as Customer Country, Product...
|
|
|
|
|
|