Lessons from Out of the Blue
This past Fourth of July weekend I had the opportunity to do a few different things and thought I would share some experiences. None of these experiences were job...
2011-07-06
7 reads
Blog Posts
ODBC DSN on 32/64 Bit Systems
Funny how you can work with data a long time and still run into something new. I’ve been working on...
2011-07-06
750 reads
Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 2
Adding In Others For Contrast
In our first part we introduced Pliant and the LS 300 drive. In part 2 we...
2011-07-06
2,955 reads
Recovering a Database
So you’re restored a database, restored a few logs, all with NORECOVERY as expected and realize there are no more...
2011-07-06
900 reads
Replacing Cursors with Set-Based SQL Queries – Part 2
Part 2 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a recent post I discussed...
2011-07-06
12,498 reads
SQL Server Analysis Services Operations Guide published
Another whitepaper to add to your “to read” list: SQL Server 2008 R2 Analysis Services Operations Guide
This white paper describes...
2011-07-06
1,043 reads
Converting OR to Union
When I looked at indexing for queries containing predicates combined with OR, it became clear that the are some restrictive...
2011-07-05
1,639 reads
Deleting Accounts from Websites
I ran across this article about How to Delete an Account from Any Website on the PC Magazine web site....
2011-07-05
918 reads
How my SQL Server trainings helped Hannes and his company to improve their SQL Server based software
In the last months I have done a lot of SQL Server consulting engagements where I
have seen the craziest performance...
2011-07-05
824 reads
July Monthly SQL Server Checklist
It’s a new month, and time to check out your SQL Servers to make sure everything is configured and working...
2011-07-05
1,035 reads
Blogs
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...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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