Database Geek of the Week - Glenn Johnson
The latest GotW award goes to Glenn Johnson, .NET trainer and author of Programming Microsoft ADO.NET Applications:
SQL Sudoko
The latest puzzle craze seems to be Sudoko with all kinds of online puzzles, books, etc. appearing around the world. Longtime SQL Server guru David Poole decided solving the puzzles was not enough of a challenge and brings us some T-SQL to help solve those difficult ones keeping you from getting back to work.
Building Database Applications with Remote Support in Mind
Although the challenges of designing and developing an embedded software package are obvious, the effort of providing remote support for the deployed application is often underestimated.
Spotlight on SQL Server with Paul Randal
What's inside the mind of the guy behind the storage engine? Steve Jones gets a few minutes iwth the lead program manager of the SQL Server 2005 storage engine. Check our his blog as well!
Web Parts in ASP.NET 2.0
Damon Armstrong demonstrates how to personalize the look-and-feel of multiple pages in your ASP.NET 2.0 applications.
Unit Testing and Code Generation
One of the fundamental skills a developer needs is the ability to test their code. Most people don't really do a good job, partly because they don't have a good process and leave testing until the end. Grant Fritchey brings us a new method of unit testing T-SQL stored procedures that can help you build automated tests for your code.
Powerful, Flexible Text-Formatting Solutions in SQL Server
You can build very powerful and flexible text-formatting solutions in SQL Server. Learn how to apply techniques that handle the simplest to the more complex text-formatting tasks.
Hiring A DBA
How do you go about looking for someone to fill a DBA position? SQL Server guru and head of the Colorado Springs PASS Chapter, Chris Shaw, brings us a look at how an experienced manager goes about filling DBA positions.
SQL Server 2005 - Unattended installation - Part I
Automating the installation of SQL Server was made simple in SQL Server 2005. SQL Server 2005 can be installed using a GUI, an ini file or just run setup.exe with a bunch of parameters.
Executing SQL Stored Procedures from inside a Web Application
This article, the last in the Stored Procedure series, will focus on RETURN parameters.
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams n;See possible answers