SQL in the City - Boston 2012
A free day of training in Boston on Oct 8, 2012. Come join Grant Fritchey, Steve Jones and more to talk about SQL Server and how you can work more efficiently.
Data Worms
Worms have been around a long time in computer systems. However changes in the global policies of governments and the possible retaliation for cyber warfare should have DBAs concerned.
Report Builder 3.0: Formatting the Elements in your Report
here is a lot that can be done to make basic tabular reports more readable, using Microsoft's free Report Builder. Rob Sheldon continues his exploration of the power of this tool by showing how to format various elements within reports.
SQL in the City - Chicago 2012
A free day of training in Chicago on Oct 5, 2012. Join Grant Fritchey, Steve Jones and more to discuss, debate, ask questions, and learn about how to better run your organizations SQL Servers.
Stairway to T-SQL DML Level 11: How to Delete Rows from a Table
You may have data in a database that was inserted into a table by mistake, or you may have data in your tables that is no longer of value. In either case, when you have unwanted data in a table you need a way to remove it. The DELETE statement can be used to eliminate data in a table that is no longer needed. In this article you will see the different ways to use the DELETE statement to identify and remove unwanted data from your SQL Server tables.
SQL in the City - San Francisco 2012
The city by the bay welcomes Steve Jones, Grant Fritchey and more for a day of debate, discussion and learning about SQL Server. It's free. Just register and join us.
Compress Everything
Data grows constantly and the size of some of our databases seems to have no end in sight. Steve Jones notes that we might just want to compress everything, just to keep up.
Run an Oracle package from SQL Server Integration Services
If you want to run an Oracle Package and then execute a web service, copy files or folders, a sequence of tasks, you may need to use SQL Server Integration Services (SSIS).
SQL in the City - Austin 2012
A free day of training in Austin, TX with Grant Fritchey, Steve Jones and a few others. Join us to learn about SQL Server and how you can more efficiently work in your job every day.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Alamat kontak resmi BCA KCP Buaran Raya Telp:0817866887
WhatsApp:0817866887 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren Sawit,...
Alamat kontak resmi BCA KCP Taman Melati Telp:0817866887
WhatsApp:0817866887 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji, Kota...
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
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