Challenge Yourself
How do you grow your career? Steve Jones has a few ideas on what you can do to both improve your skills and build your brand.
Synchronize Salesforce with SQL Server using SSIS
Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.
Change All Computed Columns to Persisted in SQL Server
Aaron Bertrand recently answered a question from a user who wanted to convert all of their SQL Server computed columns to be persisted. This allows you to shift the SQL Server cost of performing the computation from query time to the time of the insert/update, at the cost of storage. In this tip, Aaron shows you how.
Webinar: 7 Steps to Build a Database Deployment Pipeline
Join Red Gate’s Alex Yates and TeamCity for a free webinar this Thursday, October 2nd. In this practical demo, Alex will show you how to set up continuous delivery for your SQL databases using TeamCity, Red Gate’s SQL Automation Pack, and Octopus Deploy. Places are limited – register now.
Database Checkups
It's important that you are watching your databases' health to be sure that you can make changes, as well as rollback patches when issues occur.
I am no Asimov
Rodney Landrum on finding the inspiration you need, somehow and from somewhere, to get yourself out of a tight corner.
Removing SQL Server Management Data Warehouse (Data Collector)
Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.
Azure Diagnostics for Virtual Machines
Hosting a scalable application in Azure seems ideal, but what happens when things go wrong? Azure Cloud Services provide extensive diagnostics, and this feature has now been extended to Azure web sites and Azure Virtual Machines. You need to set up diagnostics on the VM, but once this is done, all your logs, traces and performance counters can be collected from many VMs in one place for easy management.
#SQLPASS Election Interview with James Rowland-Jones
An interview with James Rowland-Jones in advance of the PASS election.
Blogs
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...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
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