Comments Feed

Parsing Denormalized Strings with the STRING_SPLIT Function in SQL Server 2016 Commented on: 5 weeks ago (March 23, 2017)

Thanks! I thought I caught all those. For some reason SPLIT_SCREEN started registering in my head as I was writing the article.

SQL Server Management Studio Version 16.5.2 Now Available for Download Commented on: 13 weeks ago (January 26, 2017)

I've received the following information directly from the program group at Microsoft: "We had a customer report an issue that our perf fixes for OE table nodes has an issue with sparse columns....

Identifying Orphaned Logins Commented on: 16 weeks ago (January 5, 2017)

I'm always looking for ideas for articles. I just saw this comment and will write something up specifically to address this question for you Shankar. Stay tuned. Will get it out this month!

How Old Are Your Backups? Commented on: 16 weeks ago (January 5, 2017) Hi David and happy new year to you as well. I'm making use of template parameters in the script in the area you're referring to. To better understand template params check out these two articles: "...
What Every Accidental DBA Needs to Know Now: Backups Commented on: 32 weeks ago (September 13, 2016)

Thank you for such a kind comment. You don't know how we authors appreciate the feedback. Usually we feel we just send these articles out into the wild and never hear anything about how they are...

Top Insights You Can Gain from the Usage Stats Dynamic Management View (Part 1) Commented on: 1 year ago (February 8, 2016)

Good point. I'll edit the script to note that and also provide an alternate for older versions back to 2005. Thanks.

Identifying Query Text and Graphical Execution Plans in Active Queries Commented on: 1 year ago (December 10, 2015)

Anggara, this works fine when I copy and paste it into SSMS. There is nothing to fix syntactically. Can you tell me what version of SQL you're running and the collation setting if not default?

Identifying High-Impact Queries and Stored Procedures with Dynamic Management Views Commented on: 1 year ago (October 2, 2015)

I suspect you may not have swapped-out the template parameter in the WHERE clause.

If you want to return results for the entire instance then comment out the WHERE clause otherwise use the...

The Myth About Estimated Execution Plans Commented on: 1 year ago (September 3, 2015)

Jason, I must apologize, but I inadvertantly deleted as spam your response when I meant to delete one purporting the commenter's new relational database written by himself should replace SQL since...

CTP 2 of SQL Server 2016 Now Available Commented on: 1 year ago (May 27, 2015)

Ah, it appears there are benefits to being an MVP. MVPs get in today; public tomorrow!

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Sep 15, 2016

Power BI Desktop “Publish to Pyramid Server” Button

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More
Jul 6, 2016

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More

Sponsored Introduction Continue on to (or wait seconds) ×