SQLintersection Spring 2019
As we head towards our SQLintersection Spring 2019 in June (our 13th show), I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet! One of the pieces of feedback we hear over and over is that att …
Registration Open for My SQLSaturday Sacramento Workshop
I’m coming to Sacramento this year for SQLSaturday #885. On Friday, I’ll be teaching a one-day pre-con: Performance Tuning in 21 Demos – You’re a developer or DBA who wants to tune indexes and queries to make your applicati …
Based in Dallas, TX? Join Redgate and Braumiller Law Group at their GDPR event tonight.
Join the FACC DFW for a night of innovation and European-American networking across industries. We invite you to a discussion with experts from Braumiller Law Group and Redgate Software UK to help answer your questions and learn about GDPR in copious c …
Breaking the 4th Wall with Unity
Even when creating games, your code has access to environment variables and document files. In this article, Lance Talbert shows how to access files to convince the player that maybe the game knows more than it should.
Offline R Services installation and patching
The R Services installation package is not included in the MS SQL Server installation package. When you install MS SQL Server with R Services the installer actually download the package from the Internet.
Consulting 104 – Why Do I Give All the Performance Tuning Scripts to My Customers? – SQL Server Performance Tuning
This is the fourth of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts which are the essence of my consulting business. You can also call it my bus …
Should we use stored procedures or queries built in the app?
A client asked a great architecture question that deserved its own blog post: Should we use more “stored procedures” for select, insert, update, delete or should that just be sent as queries from the application? If you ask a junior databas …
Indexes with Included Columns: Stairway to SQL Server Indexes Level 5
Included columns enable nonclustered indexes to become covering indexes for a variety of queries, improving the performance of those queries and with the only overhead being an increase the size of an index.
Create Azure Data Lake Linked Service Using Azure Data Factory
In this article we walk through a step-by-step example on how to create an Azure Data Lake Linked Service in Azure Data Factory v2.
Consulting 103 – Why Do I Assure SQL Server Performance Optimization in 4 Hours? – SQL Server Performance Tuning
This is the third of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts which are the essence of my consulting business. You can also call it a …
How to Determine Activity on Each Processor in SQL Server
The contents of the SELECT, WHERE and ORDER BY clauses are all a matter of determining the story you need to tell.
Uploading On-Premises Data as JSON to Azure Blob Storage using SSIS
SQL Server Integration Services (SSIS) provide a broad set of tools for working with data, mostly for ETL scenarios, but you can use it for other tasks, as data movement or monitoring solutions. Packages are stored as .dtsx files, and you use SQL Serve …
What Are You Going to Do About SQL Server 2008?
Last week, you used SQL ConstantCare® to analyze 2,396 SQL Servers across a variety of versions: Alas, poor SQL Server 2008 15% (362 instances) of SQL Server 2008 and 2008 R2 18% (438) SQL Server 2012 27% (650) SQL Server 2014 32% (777) SQL Server …
Creating CRUD Stored Procedures in SQL
Back to the basics: learn how to Create, Read, Update and Delete operations are pivotal for any database application. Plus, you’ll see how to use Stored Procedures to manipulate data on the database side instead of on the application side.
Experiments with full text search
Would a crazy idea using full text thesaurus and phonetic keys actually have worked?