Accessing your SQL Server without Enterprise Manager or Management Studio can be a difficult task without a custom application. Especially if you are not in the office. Jacob Sebastian brings us an open source application that can make this much easier for DBAs.
2008-05-27 (first published: 2007-06-27)
7,595 reads
Quickly becoming the SQL Server XML expert, Jacob Sebastion brings us a great new article that expands upon his very popular series on XML in SQL Server. This time he examines the FOR XML PATH option, which provides additional formatting capabilities.
2008-05-22 (first published: 2007-06-20)
20,755 reads
Tracking changes to your development environments is important to ensure that your deployments to production go smoothly. Jacob Sebastion brings us a look at how well the Visual Studio Team System Edition for Database Professionals can help you with this task.
2008-05-19 (first published: 2007-07-25)
6,585 reads
Continuing on with his amazing series on XML, SQL Server MVP Jacob Sebastian shows us how to use XML in SQL Server 2005 to generate an ATOM feed.
2008-05-15
3,203 reads
Continuing on with his series on XML, Jacob Sebastian looks at some more advanced XML techniques in SQL Server 2005.
2008-05-05 (first published: 2007-05-09)
29,508 reads
In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.
2008-05-02 (first published: 2007-05-30)
69,585 reads
Continuing on with part 18 of his series, MVP Jacob Sebastian examines building an RSS feed in T-SQL.
2008-04-09
6,516 reads
How many times have you wished that your queries performed better? Performance Tuning is a bit of an art, but learning about new techniques and which things work help grow your knowledge. Jacob Sebastian brings us the first part of a series on writing better performing queries.
2008-03-31 (first published: 2007-05-22)
30,074 reads
Jacob Sebastian brings a little more complexity to working with XML documents. Here we learn how to iterate through a document and use each node and perform some action on each one.
2008-03-26
13,754 reads
Continuing on with his series, Jacob Sebastian shows how you can shape the query results to a certain pre-defined XML structure in this article.
2008-03-19
4,818 reads
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item DBCC CHECKDB Limits III
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers