Using Dynamic Values in XMLA A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values to XMLA for a backup script. The popular answer at the time I saw it was to dynamiclly create and drop a SQL job to run the script every time you need it to…
| News From the Frontlines |  |
Tag Archive: XML in SQL
T-SQL Tuesday #17: Using Apply to Demystify Deadlocks
T-SQL Tuesday #17: Using Apply to Demystify Deadlocks This blog entry is participating in T-SQL Tuesday #17, hosted this month by Matt Velic (Blog|@mvelic). You are invited to visit his blog to join the blog party. You are welcome to write your own participating blog post for the party or just to read more blogs…
(1 votes, average: 5.00 out of 5)
Loading ...T-SQL Tuesday #16: Using Aggregate Functions in XML
T-SQL Tuesday #16: Using Aggregate Functions in XML This blog entry is participating in T-SQL Tuesday #16, hosted this month by Jes Schultz Borland (Blog|@grrl_geek). You are invited to visit her blog to join the blog party. You are welcome to write your own participating blog post for the party or just to read more…
(No Ratings Yet) Loading ...Find Cached Query Plans By Index Name
Find Cached Query Plans By Index Name A following question came in via the #sqlhelp hash tag on Twitter: Trying to find the plans using a specific index in the plan cache using XQuery – any ideas out there? #sqlhelp I replied with a little information but felt the full answer could not be shared…
(1 votes, average: 5.00 out of 5) Loading ...T-SQL Tuesday #010: Indexes: To Be or Not To Be (a B-tree)
T-SQL Tuesday #010: Indexes: To Be or Not To Be (a B-tree) This blog entry is participating in T-SQL Tuesday #010, hosted this month by Michael J Swart (Blog|@MJSwart). You are invited to visit his blog to join the blog party. You are welcome to write your own participating blog post for the party or…
(2 votes, average: 5.00 out of 5) Loading ...Transferring Logins to a Database Mirror
Transferring Logins to a Database Mirror I recently discovered that my book (Pro SQL Server 2008 Mirroring) has an older version of the script to copy logins to the mirror partner for database mirroring. The final version of the script handles SQL logins as well as Windows groups and users. I’m really disappointed that the…
(1 votes, average: 5.00 out of 5) Loading ...-
My SQL Server Magazine Articles
- Database Mirroring for Disaster Recovery September 16, 2011
- Comparative Review: Database Schema Comparison Tools August 24, 2011
- 3 Log Shipping Techniques June 22, 2011
- Hardening SQL Server June 20, 2011
- Review: ScriptLogic Security Explorer for SQL Server February 8, 2011
-
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS