SSIS Deployments with SQL Server 2012
This article describes different methods for deploying your SSIS projects to a server.
Who Wants to Be Rich?
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
Move an On Premise SQL Server Database to the SQL Azure Cloud
I’ve introduced my manager to SQL Server’s cloud based platform, SQL Azure and Windows Azure Virtual Machine. He wants to test functionality with some of our applications, which would require me to move my on premise databases to the Azure Virtual Machine. What is the easiest way to accomplish this task? See how it is done in this tip.
SQLServerCentral.com Users Survey 2013 - Last week
The SQLServerCentral.com survey will end on Wednesday August 21st. Let us know how we're doing and be in with a chance to win a $100 Amazon gift card. Winners will be announced later that week.
Lossy data and incorrect data
Your copier could change data when creating an image. Phil Factor has some words of caution.
What’s New with SQL Server 2014
In this article Greg Larson outlines the exciting new features that come along with SQL Server 2014. He'll also let you know where you can download CTP1, as well as where you can find additional resources related to SQL Server 2014.
How to Compile, Deploy and Consume a SQL Server CLR Assembly
Specialized tasks like cryptography require external libraries that are not available in SQL Server. Methods for such tasks can be compiled in a .NET language and deployed to SQL Server as a CLR assembly where the assembly's methods can be referenced by SQL Server stored procedures and functions.
Patch Problems
A few recent Patch problems have Steve Jones concerned about the directions we are going with software.
SQL in the City Seminar San Diego 2013 – DBA Team Seminar
Join Red Gate for a free seminar on September 20 (the day before SQL Saturday San Diego). SQL Server MVPs, Steve Jones and Grant Fritchey will present informative sessions featuring best practices for SQL Server database administration, in addition to showing Red Gate tools in action.
The SQL of Gaps and Islands in Sequences
Some SQL problems are intriguing because, just when good methods emerge and are accepted, other alternative solutions are discovered. The fun of exploring problems such as 'Gaps and Islands' is all the greater when we have a thorough test-harness to try out the alternative solutions.
Blogs
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers