The Cloud
I was interested to hear about Microsoft providing some services and storage in the "Cloud." I remember hearing about Amazon making disk space and computing services available to users.
What Could Go Wrong?
It's the law of unintended consequences: things happening that you don't expect from a seemingly unrelated area. This article talks about a data center having leaks from carpet cleaning above. The concrete floor had aged and the carpet cleaners dumped water on the carpet to soak it through and it leaked. I'm not sure how people have data centers below office floors, but I know I've had a number of them at different companies where I've worked.
How to troubleshoot Service Broker problems
In this one I'll discuss some of the problems that can arise and how to troubleshoot them.
Script Task Breakpoints in SQL Server 2008
One of the things coming from our look at SQL Server 2008 Integration Services is that you are not going to see a lot of change visually. What you are going to see is things going on underneath the covers that makes SSIS perform better, and improved informational messages from the components. Just such a change is seen in the Script task.
SQL Server 2008 - The Power of Merge
We have a first look at one of the features in SQL Server 2008 that was cut from SQL Server 2005, but which has been highly anticipated. How many times have you written an "insert new, update match" routine? Jacob Sebastion shows us easy this becomes with the new MERGE keyword in SQL Server 2008.
Making the Most of Operational Analytics with Enterprise Decision Mana
EDM solutions are a logical and often necessary complement to operational analytics.
Setting Up Delegation for Linked Servers
Learn how to set up delegation on your SQL Server instances, so you can use the impersonate options when setting up the security properties of linked server definitions.
Finding Column Dependencies
Most experienced DBAs know that sysdepends is not very reliable, so how can you find the dependencies inside your database? New author Christian Buettner brings us his technique for finding those hidden dependencies based on your query plans.
ASP.NET 2.0: Retrieving XML Data with XmlDataSource Control
This article shows how to retrieve both remote and local XML data and display it in a data Web control.
What Specification Server Should I Buy?
Simon Sabin is always cagey about giving advice on the sort of hardware to run SQL Server on, but admits to some general rules.
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