How to Generate a Restore Script
There are multiple ways to accomplish a database restore. But if you wanted to restore a database from a script how might you accomplish that task quickly and accurately?
2017-07-06
3,891 reads
Additional Articles
The Basics of Good T-SQL Coding Style
TSQL Code must work properly and efficiently. That's not enough though. Unless you are working alone, have perfect memory and plan to never change job, then you need to comment and document your code, it must be inherently readable, well laid out, use informative and obvious names, and it must be robust and resilient; written defensively. It must not rely on deprecated features of SQL Server, or assume particular database settings. Robert Sheldon starts a series of articles that explains the basics.
2017-07-05
7,732 reads
3 Solutions For Auditing Long SQL Server Extracts or Loads
In this post, Tim Smith looks at the different options you can use to audit your SQL Server extracts and loads during the ETL process.
2017-07-04
3,755 reads
Export data from SQL Server to Excel
What native SQL Server options are available to export to Excel? Jeremy Kadlec explains.
2017-06-30
5,930 reads
Azure Automation Methods
Tim Radney of SQLskills walks through multiple automation methods you can use to manage and maintain your Azure SQL Databases.
2017-06-29
3,697 reads
Generating HTML from SQL Server Queries
You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood as a slightly odd dialect of XML that imparts meaning to predefined tags. There are plenty of edge cases where an HTML structure is the most obvious way of communicating tables, lists and directories. Where data is hierarchical, it can make even more sense. William Brewer gives a simple introduction to a few HTML-output techniques.
2017-06-28
5,489 reads
How to Read the Transaction Log File
Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.
2017-06-27
4,882 reads
A DLM Approach to Database Testing
Database Lifecycle Management aims to make the development and modification of databases more predictable. Bugs are the source of more unpredictability than anything else, purely because it is so difficult to guess how long it will take to fix them. Good testing at all stages may take some time and effort, but it greatly reduces likelihood of the wildcard factor of the bug that is first detected during the deployment process; or worse, that gets into the production release.
2017-06-26
3,875 reads
Getting Started with Azure SQL Data Warehouse - Part 5
In part 5 of this series covering Azure SQL Data Warehouse, Arshad Ali looks at performance optimization.
2017-06-23
3,202 reads
Where's the Ops in DevOps? Part 1
In the first of a three-part series, guest bloggers from DevOpsGuys look at the real role of Ops in DevOps. Where it changes, how it changes, and why Ops...
2017-06-23
3,752 reads
Blogs
Github Copilot in SSMS can include data in its memory, simple prompt injections ahead
By Ed Elliott
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Forums
Email..euchemstore@gmail.com..buy dmt bark
Telegram..@Euchemstore1 Telegram..@Euchemstore1 Email..euchemstore@gmail.com Email..euchemstore@gmail.com DMT (N,N-dimethyltryptamine) is a powerful hallucinogenic compound found naturally in...
Email..euchemstore@gmail.com..buy dmt dc
Telegram..@Euchemstore1 Telegram..@Euchemstore1 Email..euchemstore@gmail.com Email..euchemstore@gmail.com DMT (N,N-dimethyltryptamine) is a powerful hallucinogenic compound found naturally in...
Email..euchemstore@gmail.com..buy dmt near
Telegram..@Euchemstore1 Telegram..@Euchemstore1 Email..euchemstore@gmail.com Email..euchemstore@gmail.com DMT (N,N-dimethyltryptamine) is a powerful hallucinogenic compound found naturally in...
Question of the Day
What is the original database name?
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers