sql tutorials

SQL Tutorial
3Schools-sql 




sqlZoo 


 This document  contains examples of:

• creating a table
• creating a view
• inserting rows
• updating rows
• deleting rows
• commit -- making changes permanent
• rollback -- undoing temporary changes
• enforcing integrity constraints

SQL Tutorial, Structured Query Language 101, microsoft sql, ms sql server, sql client 


SQLCourse - Interactive Online SQL Training for Beginners


This SQL programming help site lists commonly-used SQL statements, and is divided into the following sections:

• SQL Commands: Basic SQL statements for storing, retrieving, and manipulating data in a relational database.
• Table Manipulation: How SQL statements are used to manage tables inside the database.
• Advanced SQL: Advanced SQL commands.
• SQL Syntax: A single page that lists the syntax for all the SQL commands in this tutorial.

http://www.coderecipes.net/ sql tutorial

SQL GROUP BY techniques

But *WHY* Must That Column Be Contained in an Aggregate Function or the GROUP BY clause?

Collection of SQL Server Storage Best Practices
SQL Server - Speed up your Disks!

Normalizing-Denormalized Tables

Normalizing-Denormalized Tables

Links/Aliases to everything Number2

Links/Aliases to everything Number2

SMS Permissions - BITWISE "AND" with a PIVOT thrown in for pretty :)

Use data outside the SMS DB in your SMS Web Reports

Script to export SMS Web report results to an Excel spreadsheet

Script to export SMS Web report results to a CSV file
THE PROBLEM


SMS Web Reports - Passing a delimited list to SMS Web Reports like a table - (also convert list to rows in SQL)

How to get the CORRECT order when sorting on version numbers like xx.xx.xx.xx
THE PROBLEM

Outlook machine counts by version (Plus a trick to order by version PROPERLY)

ad groups\sql

PowerShell for Active Directory Examples « Dmitry’s PowerBlog PowerShell and beyond
AD cmdlets and domain statistics « Dmitry’s PowerBlog PowerShell and beyond
PowerGUI - Administrative Powershell Console Finding out the largest group in AD ...
PowerGUI - Administrative Powershell Console Mail Enabled Contacts in W2K3 ...
Hey, Scripting Guy! How Can I Use Windows PowerShell to Retrieve the Non-Unique Items in a List
--o-- PowerShelled PowerShell and Active Directory Part 9 (nested groups)
Windows Powershell Working with Active Directory -- TechNet Magazine, June 2007
Managing group membership in Active Directory with PowerShell (Part 1) Lead, Follow, or Move
Managing group membership in Active Directory with PowerShell (Part 2) Lead, Follow, or Move
PowerGUI - Administrative Powershell Console A quick intro to the Management Shell ...
Import-Export Members to a Group
List All Members of a Grouo, Including Members of Nested Groups
Project84 - Using PowerShell to find nested Groups for Active Directory Migration
AD cmdlets 1.0.3 to 1.0.4 upgrade « Dmitry’s PowerBlog PowerShell and beyond
Redmond Column Membership Has Its Privileges

windows forms
--o-- PowerShelled PowerShell Calendar Function (GUI)
Nivot Ink - Using Windows Forms Controls in PowerShell #1 ListBox
Hey, Scripting Guy! How Can I Remove EverythingFrom an Active Directory Group Except Other Groups
Hey, Scripting Guy! How Can I Configure an Active Directory Account So the Password Never Expires



Remove Password Never Expires on everyone in my AD domain - dBforums
sql
Hey, Scripting Guy! How Can I Enumerate All the Objects in an Active Directory OU
Hey, Scripting Guy! How Can I Determine if an OU is Blocking Group Policy Inheritance
Hey, Scripting Guy! How Can I List All the Sub-OUs in an OU
Allen White Accessing SQL Server data through PowerShell
AzamSharp Using PowerShell to View Images in Database
Allen White Using PowerShell and SQL Server Together
Allen White PowerShell, SQL Server and Large Resultsets
Learn SQL Server
T-SQL Programming
Custom reports in Management Studio, using the Performance Dashboard
Jeffrey McManus Database Queries with Windows Powershell
Hey, Scripting Guy! How Can I Use Windows PowerShell to Pull Records From a Microsoft Access Database
Comparing Python and PowerShell DBA Scripting
Beginning SQL Server 2005 Reporting Services Part 1
Precision Computing - Interacting with SQL Databases in PowerShell Invoke-SqlCommand
Reporting Services Cribsheet

ad groups\sql

PowerShell for Active Directory Examples « Dmitry’s PowerBlog PowerShell and beyond
AD cmdlets and domain statistics « Dmitry’s PowerBlog PowerShell and beyond
PowerGUI - Administrative Powershell Console Finding out the largest group in AD ...
PowerGUI - Administrative Powershell Console Mail Enabled Contacts in W2K3 ...
Hey, Scripting Guy! How Can I Use Windows PowerShell to Retrieve the Non-Unique Items in a List
--o-- PowerShelled PowerShell and Active Directory Part 9 (nested groups)
Windows Powershell Working with Active Directory -- TechNet Magazine, June 2007
Managing group membership in Active Directory with PowerShell (Part 1) Lead, Follow, or Move
Managing group membership in Active Directory with PowerShell (Part 2) Lead, Follow, or Move
PowerGUI - Administrative Powershell Console A quick intro to the Management Shell ...
Import-Export Members to a Group
List All Members of a Grouo, Including Members of Nested Groups
Project84 - Using PowerShell to find nested Groups for Active Directory Migration
AD cmdlets 1.0.3 to 1.0.4 upgrade « Dmitry’s PowerBlog PowerShell and beyond
Redmond Column Membership Has Its Privileges

windows forms
--o-- PowerShelled PowerShell Calendar Function (GUI)
Nivot Ink - Using Windows Forms Controls in PowerShell #1 ListBox
Hey, Scripting Guy! How Can I Remove EverythingFrom an Active Directory Group Except Other Groups
Hey, Scripting Guy! How Can I Configure an Active Directory Account So the Password Never Expires



Remove Password Never Expires on everyone in my AD domain - dBforums
sql
Hey, Scripting Guy! How Can I Enumerate All the Objects in an Active Directory OU
Hey, Scripting Guy! How Can I Determine if an OU is Blocking Group Policy Inheritance
Hey, Scripting Guy! How Can I List All the Sub-OUs in an OU
Allen White Accessing SQL Server data through PowerShell
AzamSharp Using PowerShell to View Images in Database
Allen White Using PowerShell and SQL Server Together
Allen White PowerShell, SQL Server and Large Resultsets
Learn SQL Server
T-SQL Programming
Custom reports in Management Studio, using the Performance Dashboard
Jeffrey McManus Database Queries with Windows Powershell
Hey, Scripting Guy! How Can I Use Windows PowerShell to Pull Records From a Microsoft Access Database
Comparing Python and PowerShell DBA Scripting
Beginning SQL Server 2005 Reporting Services Part 1
Precision Computing - Interacting with SQL Databases in PowerShell Invoke-SqlCommand
Reporting Services Cribsheet

GalaXQL - Interactive SQL tutorial

GalaXQL - Interactive SQL tutorial

Who said SQL tutorials have to be boring?

WQL to SQL
This SQL Query can be used to see how WQL is converted to SQL by SMS for collections.
SelectCollections.SiteID, Collections.CollectionName, Collection_Rules.QueryName, Collection_Rules_SQL.WQL, Collection_Rules_SQL.SQL From Collections,Collection_Rules, Collection_Rules_SQLWhere Collections.CollectionID = Collection_Rules.CollectionIDAND Collections.CollectionID = Collection_Rules_SQL.CollectionID

linq

The LINQ Project
Visual Studio 2008 Samples Page
LINQ to SharePoint - Home
LINQ to Active Directory - Home
ADO.NET Samples - Home
LINQ Expression Builder - Home


Understanding LINQ to SQL Query Translations - ScottGu's Blog

LINQ to SQL Debug Visualizer - ScottGu's Blog
Part 1: Introduction to LINQ to SQL
Part 2: Defining our Data Model Classes
Part 3: Querying our Database
Part 4: Updating our Database
Part 5: Binding UI using the ASP:LinqDataSource Control
Part 6: Retrieving Data Using Stored Procedures
Part 7: Updating our Database using Stored Procedures
Part 8: Executing Custom SQL Expressions
LINQ to SQL (Part 9 - Using a Custom LINQ Expression with the aspLinqDatasource control) - ScottGu's Blog

Recipe Deploying a SQL Database to a Remote Hosting Environment (Part 1) - ScottGu's Blog Tip-Trick How to upload a .SQL file to a Hoster and Execute it to Deploy a SQL Database - ScottGu's Blog
SQL Server Hosting Toolkit - Home Database Publishing Wizard

myITforum_sms scripts

Query for machine with no logged on user for 30
may need to change the quotes around the numbers to single to get it to
quote:select SYS.Netbios_Name0, SYS.AD_Site_Name0, OS.LastBootUpTime0, WS.LastHWScan as 'Last Reported to SMS' from v_GS_Operating_System OS join v_r_system SYS on OS.ResourceID=SYS.ResourceID join v_gs_workstation_status ws on sys.resourceid=ws.resourceid Where OS.Version0 = '5.1.2600' and datediff(day,ws.LastHWScan,getdate()) < "2" and datediff(day,OS.LastBootUpTime0,getdate()) > "14" Order by SYS.AD_Site_Name0, OS.LastBootUpTime0

anyone have a vbs to edit registry key and push out wit...

sms client health script

sms sql help

Distributing a file from a central location overnight -

Simple way to identify/correct duplicate machines in co...

How to troubleshoot SMS Administrator console connectivity

gather the information contained in the local workstation’s “Administrators” group.

reporting services links

links about reporting services available here mike mccafferty reporting services

sql joins

SQL Joins and Keys
Understanding SQL Joins
Getting the Right Data with SQL Joins
How IT Works A Primer On SQL Joins -- TechNet Magazine, Spring 2005
SQL joins - multi-table queries

SQL Server Service packs and Versions

http://vyaskn.tripod.com/sqlsps.htm

SQL Server 2005 Service Pack 2

SQL Server 2005 Service Pack 2

sql 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

Administering backup and recovery for Windows SharePoint Services 3.0 technology

sharepoint designer

Microsoft SharePoint Designer Team Blog

Windows SharePoint Services 3.0 SDK
Browse the SDK information on MSDN online.


Learn Windows SharePoint Services
Find books, screencasts, SDKs, training courses, webcasts, and more to expand your skills as a Windows SharePoint Services developer


Part 4 – SharePoint and Access 2007

SharePoint Webcast Series

Part 4 – SharePoint and Access 2007

MSDN Webcast: Building Collaborative Applications Without Code Using Office SharePoint Designer 2007 (Level 300)

buck woody on sql

TechEd Bloggers - Buck Woody
SQL Server Reference Guide
SQL Server Reference Guide Building a SQL Server Lab
How Do I do that with SQL Server

SQL Server Instances

SQL Server Instances

32- vs 64-bit Computing for SQL Server

32- vs 64-bit Computing for SQL Server

Locating Machines Not Reporting Heartbeat Discovery In The Last

Locating Machines Not Reporting Heartbeat Discovery In The Last Week - Don Hite

This SQL query will allow you to find or locate machines in your SMS database that have not reported a Heartbeat discovery record in the last week or seven days.

SQL Query:

Select
SD.Netbios_Name0,
A.AgentName,
DI.AgentTime

From System_Disc SD

Inner Join DiscItemAgents DI on SD.DiscArchKey = DI.DiscArchKey
Cross Join Agents A

Where A.AgentName = 'Heartbeat Discovery'
And DatePart (D,DI.AgentTime) >= 7

WQL to SQL

Garth Jones WQL to SQL