A Red Gate Meetup in San Francisco
Join Neil Davidson, Joint CEO of Red Gate Software, for a meetup in San Francisco on Aug 25th. Come talk software, databases, and development with other like-minded people.
Using PowerShell to Manage SQL Server
The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs.
Back to Basics
This week Steve Jones reminds us that the basic skills we may take for granted might need some refreshing or updating.
Configuring Database Mail with Powershell and SMO
Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.
Keeping Your Soul
How much do you need to sacrifice to succeed in business? It might be a lot, but Steve Jones says a lot of financial success is not worth losing your soul over.
SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Processing Task
The primary purpose of SQL Server 2008 Integration Services is to deliver extraction, transformation, and loading (ETL) functionality that supports core features of the SQL Server database management system. However, there are numerous scenarios where its role involves interaction with components that provide business intelligence-related features incorporated into the product.
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 3
This article continues the series on how to create a 2 node Windows\SQL Server 2008 cluster with a look at slipstreaming the service pack and cumulative updates needed.
Tricky Questions
This Friday Steve Jones is looking for help with interview questions. What questions have been hard in an interview or surprised you? Let us know and help others be prepared for their next interview.
Simple Script to Backup All SQL Server Databases
Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks. One of these tasks may be the need to backup all databases on your server.
Change Tracking and Database Refactoring
Using change tracking in SQL Server 2008 to aid in database refactoring within an OLTP system.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
Apakah UOB ada WhatsApp
Kini Anda bisa menerima info penting resmi dari UOB Indonesia melalui WhatsApp bisnis yang...
BCA KCP Mohamad Toha Telp/wa 085169998765
Telp/wa 085169998765 Jl. Moch. Toha No.197, Cigereleng, Kec. Regol, Kota Bandung, Jawa Barat 40253
BCA KCP Tentara Pelajar TLP/WA 08218573837
Jl. Tentara Pelajar No.95, Malimongan, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90173
Question of the Day
Creating a JSON Document III
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 TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers