Adoption
Are lots of people adopting SQL Server 2008? Should you be looking at it? Steve Jones has a few comments on what the new lifecycle of SQL Server might mean for DBAs and developers.
Adoption
Are lots of people adopting SQL Server 2008? Should you be looking at it? Steve Jones has a few comments on what the new lifecycle of SQL Server might mean for DBAs and developers.
Mapping Database Principals to Server Principals
A question on the forum asked how to find all the database mappings for a particular login. If you're on SQL Server 2000 or below, the tables you want to use are syslogins in the master database and sysusers in each database.
SQL Server Encryption Key Management between Development, Test and Production Environments
The company I work for has decided to use the encryption technology available in SQL Server 2005. We have almost everything ironed out except for which keys to use in the development, testing, and production environments. Should we use one key for all three environments or different keys for each?
The Safe and Easy Way to Delete All Data in a SQL Server DB
Deleting all the data in a SQL Server database doesn't have to involve complex code. The undocumented stored procedure sp_MSForEachTable safely bypasses built-in limitations to accomplish this common task.
You Must Trust Your DBAs
This is a follow-on post to You Must Trust Someone. My point in that post was to establish that being able to and and actually trusting your account and server administrators is a necessity. I didn't go into the business aspect of that, but basically it boils down to having a good selection process for candidates, checking out their references, ...
A Cloudy Week - Database Weekly (Mar 2, 2009)
There has been a lot of news about cloud computing this past week, including an announcement about SQL Server.
Columbus SQL Server Users Group
If you are near Columbus, GA, a new SQL Server Users Group is starting up.
Guest Editorial: Information is Power
Phil Factor muses on the power, and potential failings, of the relational database, and wonders if those responsible for its development should feel any guilt about the opportunities for abuse of the power that it affords.
Learn SQL Server BI in Arabic
Learn about the Business Intelligence systems of SQL Server with a series of free videos in Arabic.
Blogs
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers