recentpopularlog in

david.parrott : sql   38

Bad habits : Putting NOLOCK everywhere - SQL Sentry
Aaron Bertrand (@AaronBertrand) discusses the NOLOCK hint in SQL Server, and why you want to avoid slapping it onto every table mentioned in every query.
sql  development 
november 2016 by david.parrott
10 SQL Tricks That You Didn’t Think Were Possible | Java, SQL and jOOQ.
Listicles like these do work - not only do they attract attention, if the content is also valuable (and in this case it is, trust me), the article format can be extremely entertaining. This article will bring you 10 SQL tricks that many of you might not have thought were possible. The article is a…
database  sql 
april 2016 by david.parrott
It’s Time To Get Over That Stored Procedure Aversion You Have — Rob Conery
Running away from Stored Procedures is ridiculous, let your database do what it's good at!
database  data  sql 
february 2015 by david.parrott
TSQLUnit
TSQLUnit is a testing framework to write tests for applications written in Transact-SQL.
opensource  database  sql  sqlserver  testing  tdd 
august 2011 by david.parrott
tSQLt
tSQLt is a unit testing framework for Microsoft SQL Server. tSQLt is compatible with SQL Server 2005 (service pack 2 required) and above on all editions.
database  sql  sqlserver  testing  tdd 
august 2011 by david.parrott
SQL Server Database Comparison Tool - CodeProject
In this article, I will show you how to create a basic DB schema comparison tool for SQL Server 2005 and SQL Server 2008.
c#  sql  sqlserver  tool  article  opensource  dotnet 
july 2011 by david.parrott
SQL Server Community FAQs eBook download - SQL Server Forum Support Team - Site Home - MSDN Blogs
Our SQL Server Forum Support Team authored, collected and consolidated those common asked questions in SQL Server MSDN and TechNet forums into this ebook so as to provide an offline reading and learning experience for IT professionals and people who are interested in SQL Server. In this ebook, there are totally about 101 items covering database administration, SSAS, SSIS and SSRS which are good references for you to handle common SQL Server problems.
sql  microsoft  sqlserver  reference  faq  ebooks 
june 2011 by david.parrott
Database .NET - A MultiDatabase Manager
Database .NET is a simple, uniform and intuitive database management tool for multiple databases, It makes Local and Remote database administration easier without installing anything(*), With it you can Create DB, Design table, Edit data, Export data, Generate scripts and run SQL queries.
database  tools  sql  development  dotnet 
march 2011 by david.parrott
Microsoft WebMatrix
WebMatrix is a free Web development tool that installs in minutes and elegantly brings together a Web server, a database, and programming frameworks into a single, integrated experience. WebMatrix lets you code, test, and deploy both ASP.NET and PHP applications side by side.
design  development  editor  free  html  php  programming  software  sql  tool  tools  web  windows  dotnet 
july 2010 by david.parrott
SSMS Tools Pack
SSMS Tools Pack is an add-in for Microsoft SQL Server Management Studio (SSMS) including SSMS Express.
It contains a few upgrades to the SSMS IDE that I thought were missing.
database  development  free  plugin  programming  utilities  tools  tool  sqlserver  sql  software  dotnet 
july 2010 by david.parrott
MyBatis Home
The MyBatis data mapper framework makes it easier to use a relational database with object-oriented applications. MyBatis couples objects with stored procedures or SQL statements using a XML descriptor. Simplicity is the biggest advantage of the MyBatis data mapper over object relational mapping tools.
database  development  java  library  opensource  programming  sql  dotnet 
july 2010 by david.parrott
WordPress on Microsoft
This site is about helping WordPress users take advantage of Microsoft technology.
blog  php  sql  sqlserver  windows  wordpress 
june 2010 by david.parrott
mysqlicious - Project Hosting on Google Code
MySQLicious provides automated mirroring/backups of Delicious bookmarks into a MySQL database.
programming  backup  database  development  opensource  free  php  web  tools  sql  software 
may 2010 by david.parrott
Log Parser 2.2
Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows® operating system such as the Event Log, the Registry, the file system, and Active Directory®.
database  development  download  free  software  sql  tool  tools  utilities  windows 
april 2010 by david.parrott
Andy Leonard
SSIS and ETL
Thoughts about Database and Software Development, and the tools of the trade.
ssis  sql  blog 
february 2010 by david.parrott
SQL in the Wild
A discussion on SQL Server code
blog  database  sqlserver  sql 
october 2009 by david.parrott
Apex SQL Refactor : Format SQL Code
ApexSQL Refactor is a FREE Add-in for SQL Server Management Studio to allow developers to quickly format their SQL code based on over 43 customizable options.
development  tools  sql  sqlserver  plugin 
october 2009 by david.parrott
SSIS Team Blog
Helpful information and examples on how to use SQL Server Integration Services.
blog  sql  sqlserver  ssis  dotnet 
september 2009 by david.parrott
Tutorial: Creating a Simple ETL Package
In this tutorial, you will learn how to use SSIS Designer to create a simple Microsoft SQL Server Integration Services package. The package that you create takes data from a flat file, reformats the data, and then inserts the reformatted data into a fact table.
tutorial  database  sql  sqlserver  ssis  dotnet 
september 2009 by david.parrott
Microsoft Sync Framework - Home
a comprehensive synchronization platform enabling collaboration and offline for applications, services and devices with support for any data type, any data store, any transfer protocol, and network topology.
programming  development  tools  download  database  sql  dotnet 
september 2009 by david.parrott
migratordotnet
Database migrations for .NET. Based on the idea of Rails ActiveRecord Migrations.
programming  development  tools  windows  opensource  sqlserver  sql  database  c#  dotnet 
september 2009 by david.parrott
LiquiBase
LiquiBase is an open source (LGPL), database-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control.
programming  development  software  tools  opensource  database  java  sql 
september 2009 by david.parrott
LINQPad
LINQPad lets you interactively query SQL databases in a modern query language: LINQ.

LINQPad is also a great way to learn LINQ: it comes preloaded with 200 examples from the book, C# 3.0 in a Nutshell.
development  programming  software  free  c#  tools  linq  download  editor  utilities  database  sql  sqlserver  tool  asp.net  visualstudio  dotnet 
september 2009 by david.parrott

Copy this bookmark:





to read