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.
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.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
Forums
BCA KCP Tanjung Duren HUB/WA 08216977749
Jl. Tanjung Duren Dalam III, Tj. Duren Utara, Kec. Grogol petamburan, Kota Jakarta Barat,...
BCA KCU SUDIRMAN Telpon/WA:0821•3111•185
BCA KCU SUDIRMAN Telpon/WA:0821•3111•185 Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi,...
BCA KCP Angke HUB/CS 08216977701
Jl. Pangeran Tubagus Angke No.37, Jemb. Lima, Kec. Tambora, Kota Jakarta Barat, Daerah Khusus...
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