The second installment of this series discussed the cost of maintaining systems with various levels of downtime, ways data can be lost, and what constitutes a backup. In this installment, I discuss how to configure your hardware to minimize the need to restore a backup.
One of the lesser used features of SQL Server is the work with text variables. These data types cannot always be manipulated with regular T-SQL. Raj Vasant brings us an introductory look at the various functions you can use to work with these fields.
The File Watcher Task does what it says really, it watches a folder waiting for files. When an available file is found the task completes, returning the name of the file for later use.
The task will detect changes to existing files as well as new files, both actions will cause the file to be found when available. A file is available when the task can open it exclusively. This is important for files that take a long time to be written, such as large files, or those that are just written slowly or delivered via a slow network link.
Whether you are building SQL Server 2000 applications or getting ready for the new features in SQL Server 2005, there are many fundamental database design principals that should be followed. New author Ranga Narasimhan brings us a look at how he handles reference tables when designing a database..
We all know the "TOP" clause returns the first n number of rows or percentage of rows thereby limiting the number of resulting rows displayed when we are selecting rows in a table.
SQL Server 2005 is packed with new features and enhancements. One of the enhancements in SQL 2005 that we are going to see is the clause, "TOP." The "TOP" clause will now allow us to do Data Manipulation and also allow similar criteria results to be displayed by using the TIES option.
SQL Server 2000 has a great set of administrative and development tools, one of the most heavily used of which is Enterprise Manager. Sushila Iyer brings us a fantastic article with some tricks in using this tool to create and manipulate tables.
Long anticipated, the arrival of radically restructured database architectures is now finally at hand.
Continuing with the humanization of the amazing team hard at work on SQL Server, Steve Jones takes a few minutes with Donald Farmer, BI guru.
Another great article from Joe Sack that looks at a great technique for generating reports in Excel for your users. Using DTS, you can easily setup an ad hoc or recurring schedule for your users. It's a way to quickly build a report that keeps people happy while making you look like a genius.
Richard Hundhausen is the author of Building Web Applications with ADO.NET and XML Web Services and Programming ADO.NET, both from Wiley, as well as the upcoming Working with Microsoft Visual Studio 2005 Team System from Microsoft Press. He is also a trainer, teaching numerous courses and speaking at conferences such as VSLive and Tech Ed.
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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