Doctor Who 2 (12/27/2016)

---

Eric M Russell (12/27/2016)

---

Did you download it from a MSDN subscription or from Visual Studio Dev Essentials members?

I think there is a feature in the SQL Server...

Outside of an ETL staging environment, the routine usage of RegEx expressions would indicate something is amiss in the data model design or data quality.

I would import the records from the .csv file into a user table (not a temp table), and then create a primary key on DriverMD5 column. The other table, the...

Did you download it from a MSDN subscription or from Visual Studio Dev Essentials members?

I think there is a feature in the SQL Server installation called 'Edition Upgrade' where you...

Distributing tables vertically (ie: ServerA contains a subset of data for current year and ServerB contains archive data same tables) can be an effective scale-out solution (depending on the access...

Apps that pull data across VPN, like SSMS or SSIS, can be impacted by network latency.

One thing you can do is poll SYS.DM_OS_WAIT_STATS for network related wait states during...

To identify what specific task or event is the bottleneck, you can look at the SSIS Executions report.

\'Integration Services Catalogs'

\SSISDB

\ProjectName (typically name of your package)

Right click on project

Reports..

All Executions..

Also, the...

Erland Sommarskog maintains an article describing various techniques and considerations for implementing this type of generic search procedure where the entities, predicates, and parameters are broadly defined.

Dynamic Search Conditions...

If your application needs to join Customers with PurchaseOrders, and your Customer table on ServerA, and your PurchaseOrder table on ServerB, then that architectural decision itself has forced you down...

I don't know much about how those time traveling DeLoreans work, but...

Anyone here deer hunt?

Any tool that can present an input form and execute a stored procedure call can be used for this. Actually, your existing reporting tool probably has limited capability for this....

It's 2016, and folks are still coding really bad T-SQL. The problem is that many organizations see T-SQL coding simply as an extension of C# or Java coding. Those of...

I'm a bit of a handy-man both around the house and the database server at work. Just like duct tape, I consider PowerShell to be an essential tool for a...

You'll want to setup an extended event trace to audit any permission denied related errors resulting attempts by applications to execute direct SQL statements. However, if we're just talking about...