Post SQL Server 2008 Upgrade - SQL School Video
After you complete an upgrade to SQL Server 2008, Brian Knight goes over some things you might want to do first.
How To Get Active Directory Users and Groups Using SQL Server Integration Services SSIS 2005
We would like to update the user, role, and user role tables automatically from Active Directory. Ideally we'd like an SSIS package that we could schedule and/or run on demand to take care of the update. Can you provide an example of how to do this?
SQL Techniques for Performing Operations on Matrices
SQL does not support direct operations on matrices, but it does allow easy manipulations with matrices. Learn a few SQL techniques for performing some basic operations on matrices.
An Extra Defense For SQL Injection Attacks
TDSe-cure is a proxy service to SQL Server to block SQL injection attacks.
SQL Server 2008 and Data Compression
One of the more exciting new features in SQL Server 2008 is data compression and Nicholas Cain talks a bit about how this works and how to determine if it fits in your environment.
Don't Let the Economic Downturn Get You Down
With the current economic downturn, many of us are wondering if we will still have a job by the end of this new year. Although DBAs are still in demand, no DBA job is 100% immune from layoffs. Brad suggests that now is the perfect time to invest in yourself.
Don't Let the Economic Downturn Get You Down
With the current economic downturn, many of us are wondering if we will still have a job by the end of this new year. Although DBAs are still in demand, no DBA job is 100% immune from layoffs. Brad suggests that now is the perfect time to invest in yourself.
Don't Let the Economic Downturn Get You Down
With the current economic downturn, many of us are wondering if we will still have a job by the end of this new year. Although DBAs are still in demand, no DBA job is 100% immune from layoffs. Brad suggests that now is the perfect time to invest in yourself.
Image If Everything
How much does the image you project at work matter? Is it more important than the work you do? Steve Jones asks for your opinions for this Friday poll.
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 Cempaka Putih Raya TLP/WA 08218573837
Jl. Cempaka Putih Raya No.118 B,C,D, Cemp. Tim Putih., Kec. Cemp. Putih, Kota Jakarta...
BCA KCP Cempaka Putih Raya TLP/WA 08216977749
Jl. Cempaka Putih Raya No.118 B,C,D, Cemp. Tim Putih., Kec. Cemp. Putih, Kota Jakarta...
BCA KCP Cempaka Putih Raya TLP/WA 08216366654
Jl. Cempaka Putih Raya No.118 B,C,D, Cemp. Putih Tim., Kec. Cemp. Putih, Kota Jakarta...
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