Tim Ford

Tim
R.
Ford
Owner,
SQL Cruise

Tim Ford is an independent consultant and the owner of SQL Cruise. He's a data professional, author, and community leader whose technical passions lie in creative solutions for managing and presenting data with 15 years of experience as a healthcare database administrator, architect, and team leader. Tim is an advocate for proper design, performance, and security in that sphere of information technology where "good data" truly does save lives.

Currently on the Professional Association for SQL Server (PASS) Board of Directors, Tim has oversight of the SQLSaturday program bringing free SQL Server, business intelligence, business analytics, Powershell, Excel, and professional development training to global audiences. Tim regularly provides content on database-related topics, professional development sciences and general technology commentary for SQL Server Pro, MSSQLTips, Simple-Talk, SQLServerCentral, and his own site, thesqlagentman.com.  

He's authored a book on Dynamic Management Objects with Louis Davidson and provides commentary and content in his own voice (and in 140 character bursts) on Twitter as @sqlagentman. Also, follow Tim on Google+.

Articles
Announcing our IT/DevConnections Data Platform and Business Intelligence Keynote Speaker Conor Cunningham
This year we’re excited to welcome Conor Cunningham, Partner Architect on the SQL Server Core Engine Team at Microsoft as our Data Platform and Business Intelligence Keynote Speaker to speak on features coming to SQL Server 2016.
Your Guide to the New Power BI Desktop

July 24th marked the General Availability release of major updates to Power BI Service and Power BI Desktop, Microsoft's cloud-based analytics and data visualization platform. Today's updates replace the previous "Power BI for Office 365" version and Power BI service that required either a subscription to Office 365 or Sharepoint Online for access. 

Power BI Desktop

$99 Online Training Opportunities: Week of July 26, 2015

Are you looking for online training opportunities for next week for you or your staff?

 

We have two sessions next week - both qualify for our Special Mid-Summer Training Sale providing high-quality training to you for only $99!

Take Advantage of the $100 July Madness Discount for IT/Dev Connections 2015
This July save $100 if you register for either the Essential or All Access level for IT/Dev Connections 2015
New Dynamic Management Views in SQL Server 2016 Part 1
New version of Microsoft SQL Server means new Dynamic Management Objects. This series will dig into what these diagnostic objects can (and sometimes can not) tell us about our servers.
SQL Server Management Studio Now Has Its Own Upgrade Path

A few months ago I wrote a plea to Microsoft to start the process of modernizing SQL Server Management Studio. As the main application/management tool for interacting with Microsoft's flagship database platform it has lagged behind all other advancement with the product.  Since 2005 when released as the evoloution of SQL Server Enterprise Manager it's only (apparently) been upgraded in order to provide base functionality added as features the SQL Server through (now) five releases: SQL Server 2008, 2008 R2, 2012, 2014 and now 2016. 

 

SQL Server 2016 CTP 2.1 Available for Public Download 1

June 24, 2015 marked a change in how Community Technology Previews (aka CTPs) are released for Microsoft SQL Server 2016.  In his May 27th blog post, CVP of SQL Server Development, T.K.

CTP 2 of SQL Server 2016 Now Available 5
Microsoft has released the second CTP of SQL Server 2016 to the public a week earlier than planned.
SQL Server 2014 Service (Revised) Pack 1 Now Available
The first service pack for SQL Server 2014 is available and incremented so you can differentiate between the initial (flawed) release and the correct version you should be evaluating for deployment.
The Microsoft Ignite Keynote and the End of the DBA Role (as We Know It)
Did information divulged about SQL Server 2016 and Microsoft's new mission in the Microsoft Ignite keynote signify the end of the DBA role as we know it?
SQL Server Public Preview Coming This Summer

The announcement was made this morning at the Microsoft Ignite keynote that a public preview for SQL Server 2016 will be released this summer.  "The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission-critical applications and deeper insights on your data across on-premises and cloud,” Microsoft corporate vice president T.K.

Identifying Transaction Log Backup Gaps
Transaction log backups are critical for point-in-time recovery. If you're in full recovery mode you also better be sure to be backing up those transaction logs because it's the only way to keep your log files healthy and lean.
Looking for SQL Server 2014 SP 1... Hold Off a Bit Longer
Microsoft released service pack 1 for SQL Server 2014 on April 15, 2015. Why can't we download it though?
Who Will Be Attending HostingCon 2015?
Who will be attending HostingCon 2015?
Comments
The Myth About Estimated Execution Plans
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...

CTP 2 of SQL Server 2016 Now Available
May 27, 2015

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

Table Variable Tip
April 2, 2015

We're seeing this as a browser-agnostic issue and are working to fix it inside of the CMS. Thanks for letting us know!

17 Questions Every SQL DBA Should Ask Before Supporting a New Third-Party Database
January 18, 2015

Sure! db_owner allows you to grow or add a data or log file inside your database. That being the case imagine someone doing so at a size that fills up the associated disk...

When Will Key SQL Server Processes End?
July 10, 2014

Doh! I don't often get lyrics wrong, but you're absolutely right. How about we cap off the article with the following instead: "we CAN check out anytime we like AND we're...

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 1, 2015
blog

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
Aug 27, 2015
blog

A Replacement for Maintenance Plan Backups 1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
Aug 19, 2015
blog

Looking forward to Containers

Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things either easier to manage or more fault-tolerant. Disks, for example, have long been virtualized in the sense that a single, physical, can easily be divided up into multiple logical (or virtual) volumes (or drives) just as easily as a number of discreet physical disks can also be virtualized into a single drive (via RAID) – which can further be partitioned into volumes, LUNs, and so....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×