Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
2008-08-19
70 reads
Articles
Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
2008-08-19
79 reads
Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
2008-08-19
47 reads
How to use OUTPUT clause result in SSIS 2005 / 2008 (RC0)
The OUTPUT clause was a new feature in SQL Server 2005 that can prove very handy in many situations. New author Gennadiy Chornenkyy brings us a look at how you can add this code to your SSIS packages and retrieve ID values back from the database.
2008-08-18
9,478 reads
Check your SQL Server using Windows PowerShell – Part 4
Earlier installments of this series illustrated how to ping the host, how to check all of the windows services related to SQL Server and how to check the hardware and operating system information. Part 4 of this series demonstrates how to get hard disk and network adapter information from the host machine.
2008-08-18
2,906 reads
Configure Filestream in SQL Server 2008
SQL Server 2008 offers a wide variety of features and FILESTREAM is one of the most anticipated. This article describes how to configure the FILESTREAM feature.
2008-08-18
3,256 reads
Epidemic Priority
As IT becomes more and more important to not only businesses but governments, what does that mean in the event of a disaster?
2008-08-18
54 reads
Epidemic Priority
As IT becomes more and more important to not only businesses but governments, what does that mean in the event of a disaster?
2008-08-18
59 reads
Epidemic Priority
As IT becomes more and more important to not only businesses but governments, what does that mean in the event of a disaster?
2008-08-18
63 reads
Telework Works
As a telecommuter Steve Jones has found it has increased his productivity, but he's not alone. Sun has examined their own telework program from the energy perspective.
2008-08-16
85 reads
Blogs
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Troubleshooting WQL in custom PBM conditions?
Hi, I'm currently trying to implement policy based mgmt with a condition to query...
Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups
We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...
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;See possible answers