Setting Up a Publisher - SQL School Video
Replication can be a complicated undertaking for many people. Learn how to get started by creating a publisher in this SQL School video from MVP Andy Warren.
Lassoing a Cloud
Steve Jones ends a "Week in the Clouds" with a poll asking if you might have changed your mind about using a cloud version of SQL Server.
Lassoing a Cloud
Steve Jones ends a "Week in the Clouds" with a poll asking if you might have changed your mind about using a cloud version of SQL Server.
Lassoing a Cloud
Steve Jones ends a "Week in the Clouds" with a poll asking if you might have changed your mind about using a cloud version of SQL Server.
New features in SQL Server 2008 justify migration
New features such as the FILESTREAM data type and Policy-Based Management offer clear performance enhancements that may make the decision to migrate to SQL 2008 a no-brainer.
What's my (fully qualified domain) name?
Fully qualified domain name that is. One of the little gotchas I encountered when rewriting my database mirroring automation scripts in powershell was that there is no simple way to get the SQL Server's fully qualified domain name. I didn't want to...
When was the last time your SQL Server database was restored
Often times we are asked the question "when was the last time my database was restored, and where was it restored from?" In this tip, we will look at some of the system tables that capture restore history information and how you can query these system tables to answer this question.
Becoming a Google Earth
Continuing on with a "Week in the Clouds", today Steve Jones discusses some of the challenges of cloud computing.
Using the Script Component With Multiple Outputs
This article demonstrates the use of the SSIS Script Component to create multiple outputs from unconventional data files.
.NET Basics for the Database Developer: Take the Plunge
This short introduction to .NET shows Access and SQL Server developers how to use a development tool to create connections to data and a user interface to manipulate that data.
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
BCA KCP Mal Ciputra HUB/CS (08218573837)
Mal Ciputra, Jl. Arteri Jl. Letjen S. Parman No.28 LG II No. 24, Slipi,...
BCA KCU TAMAN DUTA MAS HUB/WA (08218573837)
ABC dan 11 H, Jl. Pangeran Tubagus Angke No.10, Jelambar Baru, Kec. Grogol petamburan,...
BCA KCP Jalan Panjang HUB/WA (08218573837)
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
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