Sort
SQL Server Programmers offers consulting and development for business applications. Database services include management, auditing, and monitoring. For more than 20 years, SQL Server Programmers has maintained and designed custom database solutions. Our software alleviates process inefficiencies and opens the door for new business capabilities. We have helped 341 companies (and counting!) in a...
Rank
1
Vote
Sponsor
0.0
T-SQL For Accuracy and Performance In this chapter, we will be discussing both the data cache and the plan cache. I’ll demonstrate how the data cache helps performance, how the plan cache helps performance, and how the plan cache can hurt performance. Parameter sniffing can result in sub-optimal performance based on the plan currently in cache, but how do you know what plans are currently in...
Rank
2
Vote
Sponsor
0.0
ApexSQL offers the most comprehensive set of SQL Server DBA and Developer tools, with a broad array of award-winning tools, backend by killer support. ApexSQL is my formidable work instrument. I'm a high ROI CRM consultant, and I use this kind of product every day for my projects. ApexSQL is a...
Rank
3
Vote
Sponsor
0.0
The intersection of tools and technologies today creates a need for a conference that allows you to go in-depth with experts on the technologies you re using today but also cross over and hear what's happening with other technologies to keep you on the cutting edge.
Rank
4
Vote
Sponsor
0.0
Microsoft SQL Server database administration, information & tools for IT pros on BI, database management, performance tuning, security, T-SQL, Visual Studio, and more. In this whitepaper, you will rediscover the importance of profiling and explore interesting and useful forms of metadata that the...
Rank
5
Vote
Sponsor
0.0
Everything you need to master new skills for Development, IT, Creative Design. Tools for all learning styles, optional enterprise tools - get started! There’s some big changes coming with the release of SharePoint 2016, namely the emphasis on mobile and the cloud. In a free Webinar, expert Philip Wheat walked through some major changes as well as quite a few licensing changes that can impact...
Rank
6
Vote
Sponsor
0.0
The #1 SQL Server community and education site, with articles, news, forums, scripts and FAQs. You might think, as a developer, that nothing but the best is good enough as a development database. You might be mistaken. There is a lot to be said for LocalDB, but Ed Elliott argues that every edition has its pros and cons, and you need to consider Cloud-based resources, VMs and Containerised...
Rank
7
Vote
Sponsor
0.0
 ​Welcome to our web site! Alt SQL Developer for Oracle Alt SQL Developer is an integrated development environment for Oracle database objects and provides convenient opportunities for creating, editing, testing, debugging, and optimizing SQL queries, stored procedures in PL/SQL, including packages, functions, triggers, user-defined datatypes, etc. Alt SQL Developer focused on simplicity,...
Rank
8
Vote
Sponsor
0.0
SQLCourse.com: an interactive online training course for SQL beginners. This unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter. You will receive immediate results after submitting your SQL commands. You will be able to create your own unique tables as well as perform selects,...
Rank
9
Vote
Sponsor
0.0
Use this panel to setup your database problem (CREATE TABLE, INSERT, and whatever other statements you need to prepare a representative sample of your real database). Use "Text to DDL" to quickly build your schema objects from text. Use this panel to try to solve the problem with other SQL statements (SELECTs, etc...). Results will be displayed below. Share your queries by copying and pasting...
Rank
10
Vote
Sponsor
0.0
However, the PDF is DRM-free and can be viewed on any PDF capable device. Readers have reported that this guide works fine for modern Kindle devices:. The press referred to the book as “must-read” and it was even recommended by one of the authors of the SQL standard. “probably learned more in the first 50 pages than I’ve ever learned in that short amount of time reading a book.”. “The small tip...
Rank
11
Vote
Sponsor
0.0
Performance tuning is a tricky part. We need to analysis all points of view. Sometimes it is an easy fix and can be solved in a minute and sometimes it take a day or more to find and fix. I received many emails for performance tuning help. It has a variety of questions, that how can we tune a query and how to find out what is going on in the server, since my application team is does not give a...
Rank
12
Vote
Sponsor
0.0
When you’re dealing with a single table a table aliases is not necessary, but when you join to another table you can run into trouble. Consider the following scenario. Your stored procedure returns a list of users and passwords as illustrated in the following SELECT statement. This next tip works as long you have SSMS 2008 against any instance. You can drag the table name, column name or even...
Rank
13
Vote
Sponsor
0.0
Devart is a vendor of database management software, database connectivity solutions, and developer productivity tools. Devart is a recognized vendor of database connectivity solutions for Microsoft .NET and Embarcadero Delphi development platforms as well as database management software. Company's solutions support such databases as Microsoft SQL Server, Oracle, MySQL, PostreSQL, InterBase,...
Rank
14
Vote
Sponsor
0.0
SQL remote education. Interactive exercises on SQL statements: SELECT,INSERT,UPDATE,DELETE. This site will help everyone to gain or improve skills in building SQL Data Manipulation Language statements. To train You will have to build yourself the SQL statements for retrieval or modification of specific data required in the exercises. When Your query is incorrect, You will be able to see rows...
Rank
15
Vote
Sponsor
0.0
SQLCMS is a user friendly Content Management System for SQL Server - it's simple to use and ideal for both developers and their clients alike. SQL CMS is a Multi Award Winning web based Content Management System (CMS) for Microsoft SQL Server. SQL CMS is designed to be very simple to use, it was built with the end user in mind so is perfect for developers or their clients. SQL CMS generates a...
Rank
16
Vote
Sponsor
0.0
DigitalOcean is a simple and robust cloud computing platform, designed for developers. The first and only all-SSD cloud. Whether it's our Droplet compute instances or Block Storage, everything runs on SSD. Never run out of space with the ability to attach multiple highly available volumes up to 16TB to a Droplet. Each hypervisor has a fault tolerant and redundant 40Gbps network to ensure uptime...
Rank
17
Vote
Sponsor
0.0
PASS is the world's largest community for Microsoft Data Platform users to connect, share and learn with fellow data professionals. Join PASS today for free. DBA Fundamentals: 2016 Enhancements That Will Make your SQL Server Roar, June 21, 09:00. Pittsburgh SQL Server Users Group: Service Broker - Put Me In Coach, June 21, 14:30. PASS MN (Minnesota): PASSMN June 2016, June 21, 14:00.
Rank
18
Vote
Sponsor
0.0
SQuirreL SQL is an open-source Java SQL Client program for any JDBC compliant database. SQuirreL's functionality can be extended through the use of plugins. A short introduction can be found here. To see the change history (including changes not yet released) click here. For a more detailed introduction see the English or German of our paper on SQuirreL. SQuirreL's Wiki page can be found here....
Rank
19
Vote
Sponsor
0.0
DB2 SQL developers now have a handy reference guide with tuning tips to improve performance in queries, programs and applications. Poorly coded programs or improperly coded SQL statements are most often the culprit causing poor performance, and many developers do not really know where to start for performance improvements. By modifying application and SQL code, understanding Runstat options, or...
Rank
20
Vote
Sponsor
0.0