|
|
|
|
Latest Blog Posts
-
|
Cool and informative articles about SQL Server performance relating to IO caused by the DBCC CheckConstraints command and exploring the infamous Halloween Problem....
|
-
|
The charts provided here illustrates my complaints against SAN vendor doctrine, obstinately adhering to the concept of one large pool of disks from which all volumes are created for any purpose (data, log, and junk). There is no consideration for the...
|
-
|
SQL Server Integration Services (SSIS) is built to move data. SSIS ships with features to support the secure transmission of data. In this series, my goal is to promote awareness of these features and advocate for their use. SSIS Connection Managers In...
|
-
|
One of the benefits of joining PASS is that you get access to their expansive library of conference videos. (Membership is free. So join now. What'dya want, a hand-written invitation?!?) I want to take a moment to point out a good one that I think anybody...
|
-
|
My friend George Squillace ( LinkedIn ) shares this great post and cool SSIS Catalog Visualizations . Enjoy! :{> Learn more: Advanced SSIS Training with Tim Mitchell and Andy Leonard in Dallas, TX 9-11 Mar 2015 Linchpin People Blog: SSIS Stairway to...
|
-
|
I'm excited to announce that after a year of work, T-SQL Querying is now available in e-book form (dead trees will ship next month)! As you might guess from the author list, this book goes deep into various aspects of T-SQL -- both from querying and query...
|
-
|
Earlier this month, I decided to take a break from Twitter and Facebook. A couple of you noticed (I’m ok, Mom. Really!) so I decided to share this post. I continue to post updates about articles, blog posts, and presentations at LinkedIn , and I’m (obviously)...
|
-
|
Check out this community website dedicated to helping SQL programmers tune their most difficult and problematic queries....
|
-
|
Microsoft offers two similar, but separate, services containing the OneDrive moniker. There’s OneDrive (which is free) and OneDrive for Business (which isn’t). Strangely (as my ex-colleague Mark Wilson points out at OneDrive for Business: lots of cloud...
|
-
|
SQL Server Integration Services (SSIS) is built to move data. SSIS ships with features to support the secure transmission of data. In this series, my goal is to promote awareness of these features and advocate for their use. SSIS Connection Managers Let’s...
|
-
|
Want to learn more about SQL Server? Now's a good time to get a full day of inexpensive high-quality training on the coast in March and the west coast in April. I hope you'll join me for a full-day troubleshooting and performance tuning workshop on the...
|
-
|
In two days, I am starting my first conference trip for this year. Therefore, it seems to me it is high time to write down my plan for the first semester of this year. Of course, I m adding my food plan for each event:-) SQL Saturday #374 Vienna . On...
|
-
|
You are probably used to think to FIRSTNONBLANK and LASTNONBLANK as DAX functions related to time-intelligence calculations (usually for semi-additive measures ). However, these functions have a syntax and a behavior that can be useful in other scenarios....
|
-
|
Cool and informative articles about SQL Server numeric sequences, choosing CPUs, and trimming the T-Log....
|
-
|
Brevity. :{> Learn more:...
|
-
|
Quite often, people have filtered indexes but find they’re not being used as often as they’d like. I was reminded of this recently when I read a good post by Kendra Little from brentozar.com about filtered indexes . In it, Kendra talks about how the WHERE...
|
-
|
A commenter on my blog post Considerations when starting a new SSDT database project asked me to comment on his blog post SSDT Limitations . i wrote a response but when I tried to post it I got told it was too long: so I’m posting my response here instead....
|
-
|
I know that many of my readers appreciate finding out when free eBooks become available. Microsoft Virtual Academy has been releasing quite a few lately. You’ll find them here: http://www.microsoftvirtualacademy.com/eBooks?PRID=MVP-AU-7914 In particular,...
|
-
|
Data mining is the most advanced part of business intelligence. With statistical and other mathematical algorithms, you can automatically discover patterns and rules in your data that are hard to notice with on-line analytical processing and reporting....
|
-
|
Great news today! At the end of January it was a Connect item ( https://connect.microsoft.com/SQLServer/Feedback/Details/1090203 ) that described a possible memory leak on the SQL Server 2014. The details are as follow: sys.dm_os_memory_clerks for type...
|
-
|
In the last two years, I and Alberto Ferrari delivered many courses about Power Pivot, SSAS Tabular, and DAX. We had DAX content in many of the courses, and this created some overlapping and the lack of a clear guidance for studying DAX, regardless of...
|
-
|
SSIS Catalog Environments– Step 20 of the Stairway to Integration Services is live at the Stairway to Integration Services site at SQL Server Central ! Enjoy! :{>...
|
-
|
Office Mix is a free add-in for PowerPoint 2013. It records the screen, either a PowerPoint presentation or you can choose a specific region of your screen. It can record video, audio, or both. It also allows you to annotate your presentations with digital...
|
-
|
Hi, It's been ten days since our SQL Saturday, when I announced that I was stepping down from my position as President of the Ohio North SQL Server Users Group, and feel I should share some of my thoughts with you, the people that've made our group the...
|
-
|
It has been over 7 years now that I have made my ExecStats (current version Exec Stats 2015-02-18 ) tool publicly available (late 2007), with prototype versions going back to 2006. The two distinguishing elements of ExecStats is 1) the emphasis on cross-referencing...
|
|
|
|
|
|