willetfarm bookmarks: SQL - page: 1urn:uuid:{9A9DC287-AC0F-CA31-2CB2-DA44E44E0A8E}2024-03-28T17:01:49ZAutomate Database Restore for SQL Server9586852021-11-19T10:13:18ZZIn this article we look at how to automate a SQL Server database restore using a PowerShell script.147willetfarmCelko on SQL: Natural, Artificial and Surrogate Keys Explained - InformationWeek3509352020-07-07T05:02:08ZZSQL programming guru Joe Celko offers a classification scheme and advice on using the right keys.147willetfarmThe Curse and Blessings of Dynamic SQL3509282020-07-06T06:02:14ZZThis 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.147willetfarmFree Programming Books – GoalKicker.com3217672020-06-07T08:16:31ZZFree Programming Books on Android development, C, C#, CSS, HTML5, iOS development, Java, JavaScript, PowerShell, PHP, Python, SQL Sever and more147willetfarmFree Computer books Download | Online computer ebooks | online free computer science ebooks3217662020-06-07T08:10:55Z2020-06-07T01:17:14ZFree Computer Science ebooks,Free Computer Science ebooks download,computer science online, microsoft windows programming, Cisco certification books147willetfarmA Visual Explanation of SQL Joins3101972020-05-11T20:37:01ZZI 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.147willetfarmExport SQL to Excel3101962020-05-11T20:34:07ZZHow to export a SQL table to an Excel spreadsheet using the SQL Server Import and Export Wizard.147willetfarmGet Started Learning SQL Server - EssentialSQL Online Courses2907382020-03-13T15:37:09ZZLearn to use SQL Server Management Studio to create and run queries.147willetfarmFind Courses by Topic | MIT OpenCourseWare | Free Online Course Materials2831502020-02-19T22:07:37ZZMIT 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.147willetfarmTransact-SQL Reference (Database Engine) | Microsoft Docs1872852018-10-29T11:07:04Z2018-10-31T03:15:47ZThis 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.147willetfarmPoor SQL - Instant Free and Open-Source T-SQL Formatting1872842018-10-29T11:03:12Z2018-10-31T03:16:00ZPoorSQL.com is a free online T-SQL formatting service using the open-source .Net 2.0 Poor Man's T-SQL Formatter library.147willetfarm