Jobs for Data Scientists
Steve Jones talks about data science and the growing number of jobs that are available in this field.
Speeding Up Database Access Part 3 - Fixing Missing Indexes
Learn how to add those indexes you need in part 3 of Matt Perdeck's 8 part series on improving data access. This is based on the book ASP.NET Site Performance Secrets.
SQLServerCentral.com Best Practices Clinic: Part 5
In this article, Brad McGehee takes a brief look at four resource intensive queries that are running on the SQL Server instance that runs the SQLServerCentral.com website. Don't miss out on the competition in this article.
A Cast of Thousands
In a guest editorial, Rodney Landrum offers a light-hearted guide to role of each member of the cast in a typical SQL code deployment.
Extract Objects from SSRS Reports
A discrete list of database objects is extracted from SSRS using SQL, SSIS, and RegExtractor in order to identify reports that might break when a schema upgrade is performed.
The Impact of Outages
Steve Jones talks about the problems of outages, and why we ought to perhaps introduce failure into our systems to help us learn to cope with them.
CLR Performance Testing
Are Common Language Runtime routines in SQL Server faster or slower than the equivalent T-SQL code? How would you go about testing the relative performance objectively? Solomon Rutzky creates a test framework to try to answer the question and comes up with some surprising results that you can check for yourself.
SQL Saturday #64 - Baton Rouge, LA
Come join Steve Jones for a day of SQL Server training in Baton Rouge on Aug 6, 2011. Free training!
Geeky Distractions
This Friday Steve Jones has a non-work related, but fun poll. Let us know what your geeky media recommendations are this year.
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers