RSS feeds are becoming almost required for any type of data publication. SQL Server MVP Jacob Sebastian brings us the next installment of his XML Workshop series that looks at a series of T-SQL functions to generate the RSS formatted data.
MVP Brad McGehee shows how you can use Trace data as a source for your data collections for the new Management Data Warehouse
I am trying to build an SSIS package where the entire package is encapsulated in a transaction. In addition there is a table that needs to remain locked for the duration of the SSIS package execution. Can you provide an example of how to do this?
How quickly should security issues be reported? Steve Jones isn't sure, but he talks a bit about what we might want to do.
How quickly should security issues be reported? Steve Jones isn't sure, but he talks a bit about what we might want to do.
How quickly should security issues be reported? Steve Jones isn't sure, but he talks a bit about what we might want to do.
Although current databases limit XML processing to linear XPath or XQuery queries, existing hierarchical database techniques enable far more complex queries using standard SQL.
Continuing on with his series on the basics of being a DBA, the MAK brings us an article that shows how to restore a backup to a new database.
MVP Kathi Kellenberger covers the basics of using T-SQL to modify data in your databases.
Managing DBAs can be a challenge for both sides. Steve Jones talks a bit about some of his relationships with managers and the trouble that sometimes occurs.
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Comments posted to this topic are about the item Vector Datatype
Comments posted to this topic are about the item PRs Are Like Trouble Tickets
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers