In this article we look at how to automate a SQL Server database restore using a PowerShell script.
SQL programming guru Joe Celko offers a classification scheme and advice on using the right keys.
This is a text about dynamic SQL. Used in the right place, dynamic SQL is a tremendous asset, but dynamic SQL is also one of the most abused features in SQL Server.
Free Programming Books on Android development, C, C#, CSS, HTML5, iOS development, Java, JavaScript, PowerShell, PHP, Python, SQL Sever and more
Free Computer Science ebooks,Free Computer Science ebooks download,computer science online, microsoft windows programming, Cisco certification books
I thought Ligaya Turmelle's post on SQL joins was a great primer for novice developers. Since SQL joins appear to be set-based, the use of Venn diagrams to explain them seems, at first blush, to be a natural fit. However, like the commenters to her post, I found that the Venn diagrams didn't quite match the SQL join syntax reality in my testing.
How to export a SQL table to an Excel spreadsheet using the SQL Server Import and Export Wizard.
Learn to use SQL Server Management Studio to create and run queries.
MIT OpenCourseWare makes the materials used in the teaching of almost all of MIT's subjects available on the Web, free of charge. With more than 2,400 courses available, OCW is delivering on the promise of open sharing of knowledge.
This topic gives the basics about how to find and use the Microsoft Transact-SQL (T-SQL) reference topics. T-SQL is central to using Microsoft SQL products and services. All tools and applications that communicate with a SQL database do so by sending T-SQL commands.
PoorSQL.com is a free online T-SQL formatting service using the open-source .Net 2.0 Poor Man's T-SQL Formatter library.
