PASS Data Architecture presents Ami Levin: Where Are My (Primary) Keys?
I saw Ami Levin at the PASS Summit 2011 presenting on Loop Iterators in Execution Plans. It was on my...
2012-07-22
827 reads
Blog Posts
PowerPivot create relationships
We continue creating our PowerPivot model using Excel 2013 by adding relationships. We use two methods "manage relationships" dialog box...
2012-07-22
889 reads
PowerPivot import data from SQL Server
In this tutorial we start creating PowerPivot model in Excel 2013 (very similar in 2010) by importing data from our...
2012-07-22
1,143 reads
Redirecting a page on WordPress
WordPress creates a unique link for each of your post. They are broken out with your URL then YYYY / MM...
2012-07-22
632 reads
South Florida IT Pro Camp 2012 Presentation
Presentation and scripts from my Storing PowerShell Output session at South Florida IT Pro Camp 2012.
2012-07-22
1,110 reads
Support from Atlanta MDF
I have recently been notified that my neighboring SQL PASS Chapter Atlanta MDF will be sponsoring SQL Saturday 167 in...
2012-07-22
560 reads
ComputeReach
Man it's tough to get in all that you want to do, isn't it? I've been trying to get my...
2012-07-21
713 reads
New articles posted.
My article Plotting SQL Server Data for Data Visualization is up on MSSQLTips now and discusses using PyQt and Matplotlib...
2012-07-21
821 reads
Parallel Data Warehouse (PDW) Tip: Usage of SYSDATETIME() vs GETDATE()
Usage of GETDATE() dates back to the earliest versions of SQL server and has become the primary blade in our...
2012-07-21
2,764 reads
How to use LinkedIn to enhance your career
LinkedIn is a great resource to improve your career. It has definitely worked for me as the last 5-6 jobs I have...
2012-07-20 (first published: 2012-07-16)
3,899 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries