sql-training-courses.com

sql-tidbits.lincoln.se

SQL Tidbits

Searching with optional parameters. January 16th, 2009. Sometimes we need to have optional parameters to a query. This is a very common scenario for searches, for instances. So how do you handle optional parameters? I’ve created a small script below where I query a table with two parameters, where I can use either one or two. By using ISNULL() I get a clean and nice way to set the parameters if necessary. Please note query #1, where both parameters are null. Then all rows are returned. December 21st, 2008.

sql-tips-tricks.blogspot.com

SQL Tips And Trick

SQL Tips And Trick. SQL Tips and Tricks give you tips and tricks on how to effectively write SQL (Structured Query Language). Thursday, April 24, 2014. How to get data from table where text column contains only numeric. There might be a time that you want to get data from the table. The condition is that only fetch the data that has the specific column as nu. Posted by Niramit Soonthawong. Thursday, August 8, 2013. Best Practice for Insert Statement. Posted by Niramit Soonthawong. Monday, August 5, 2013.

sql-tips.blogspot.com

MySQL Tips and Techniques

MySQL Tips and Techniques. Interested in learning the basics of MySQL databases and querying? The examples in this blog focus on using MySQL databases for back-end web programming. Note: this blog is used jointly with Internet-related problems solved at my other programming blogs. Tuesday, October 18, 2005. New Focus and URL For Tech/Web Programming Analysis Blogs. I have 60-70 posts sketched out and want to complete a few before I go live with WebGuru (hopefully later this week or early next week). ...

sql-tools.blogspot.com

SQL tools

SQL Tools for administration and database development, Auditing, Code Generation, Scripting, Reporting and more. for quick and safe data comparison and synchronization. Friday, February 11, 2011. Calling SQL Server With A BlackBerry Phones. Posted by SQL Guru. Sunday, February 6, 2011. EMS SQL Management Studio for SQL Server. EMS SQL Management Studio 2010 for SQL Server. Posted by SQL Guru. Labels: SQL Management Studio. Tuesday, February 1, 2011. Advanced Intellisense for SQL Server developers and DBAs.

sql-tools.net

Database Management Tools

Welcome to DMT Software, Inc. DMT Software has been creating high-quality, innovative computer software since 2006. We specializes in database administration tools and utility applications for DBAs and developers. SQL Block Monitor 2. A real-time and historical blocking monitor tool for Microsoft SQL Server. Real-time SQL Server block detection and alerting. Creates live blocked process list of SPIDs being blocked, SQL involved in blocking, where locks are occurring and more. SQL Decryptor is the leading...

sql-training-courses.com

NobleProg EU | NobleProg Universe

44 20 7558 8274 (9:00 to 17:30 in the UK). 1 415 692 4083 (9:00am to 16:30 in California). Site moved to http:/ www.nobleprog.com.

sql-training-nj.com

sql-training-nj.com |

Please visit our live, public facing site at www.etektraining.com or call 800-929-3084 for more information. E-Tek Training Microsoft COSS CompTIA. Manufacturing Software ERP MRP. Implementing and Managing Microsoft Desktop Virtualization. Mid-Town New York City. MS Project Server and Project Management Training. Microsoft Exchange Server Training. Microsoft Office Application Training. Microsoft SQL Server Training. Microsoft Systems Management Server. Microsoft Visual Studio Development Training.

sql-training-ny.com

E-Tek Computer Training | Microsoft | Adobe | CompTIA | VMWare | ITIL | Training | New Jersey (NJ) | New York (NY)

Microsoft Gold Partner-Since 1998. Certified Training- Authorized Testing Center-Value Added Reseller-. Manufacturing Software ERP MRP. E-Tek Training Microsoft CompTIA Cisco Adobe Authorized Training New Jersey NJ. Microsoft Boot Camps for Certifications. Microsoft Exchange Server Training. Microsoft Office Application Training. Microsoft Project Server and Project Management Training. Microsoft SQL Server Training. Microsoft Systems Management Server Training. Microsoft Windows Client Training.

sql-training.de

SQL Training

Wissenswertes zu SQL und relationalen Datenbanken. Die Größe aller Tabellen einer Datenbank anzeigen. 16 Dezember 2014 von admin. Mit diesem Skript werden auf einer MS SQL Datenbank alle Tabellen mit den entsprechenden Größen dargestellt. Das Skript kann ohne Anpassung übernommen werden. TNAME AS TableName,. SName AS SchemaName,. Prows AS RowCounts,. SUM(atotal pages) * 8 AS TotalSpaceKB,. SUM(aused pages) * 8 AS UsedSpaceKB,. SUM(atotal pages) - SUM(a.used pages) * 8 AS UnusedSpaceKB. AND iOBJECT ID 255.

sql-training.info

SQL-Training - Andreas Wolter, Training & Consulting - Microsoft Certified Trainer, Microsoft Certified Technology Specialists in Microsoft SQL Server 2005, Microsoft Certified Database Administrator - Bochum, Ruhrgebiet und Nordrhein-Westfalen - Semin

Seminare and beratung: sql server oltp analysis and reporting services olap business intelligence etl - windows and isa server - asp.net t-sql mysql php html css. Raquo; Überblick. Raquo; High Level. Raquo; Last Minute. Über MCITP-Level hinausgehende Trainings für hohe Anforderungen. Neue Seminare für Service Broker. SQL Server 2008 R2) verfügbar.

sql-training.net

Free SQL Server DBA Tests

SQL Server DBA Test. Image used under creative commons by francescomucio. Your Free Ticket to SQL Server Administration Certification. Our DBA SQL Server Practice Tests. Help you study and revise for your SQL Server Administration exams. Take a SQL Server Admin. This service will provide you with a means of testing your SQL Server DBA knowledge before you take any expensive Microsoft exams and what's more it is completely free! So please pass this link on to your friends and get learning!