This guide covers SQL Server development and T-SQL programming topics including database migration strategies, advanced T-SQL features, and development best practices.
Key Development Topics
- Database migration strategies - Moving changes from development to production
- Advanced T-SQL features - DDL triggers, VARCHAR(MAX), cursors, and built-in functions
- Data import/export techniques - BULK INSERT, OPENROWSET, and data transformation
- Query optimization - Performance tuning and efficient query patterns
- Data integrity - Duplicate detection and constraint management
Much like regular DML triggers, DDL triggers fire in response to an event happening on the server. However, DDL triggers do not fire in response to UPDATE, INSERT, or DELETE statements on a table or view. Instead, they fire in response to Data Definition Language (DDL) statements that start with the keywords CREATE, ALTER, and DROP. Read more…
Understanding VARCHAR(MAX) in SQL Server 2005
In SQL Server 2000 and SQL Server 7, a row cannot exceed 8000 bytes in size. This means that a VARBINARY column can only store 8000 bytes (assuming it is the only column in a table), a VARCHAR column can store up to 8000 characters and an NVARCHAR column can store up to 4000 characters (2 bytes per unicode character). This limitation stems from the 8 KB internal page size SQL Server uses to save data to disk. Read more…
More Articles
BULK INSERT Data into a SQL Server table from a CSV file
SOUNDEX() helps you find that last name
Detect duplicate rows in a SQL Server table
Filter stored procedure resultset with ISNULL
Import data into SQL Server tables
For a modern SQL development experience with advanced features like syntax highlighting, query formatting, and result visualization, try Beekeeper Studio.
Beekeeper Studio Is A Free & Open Source SQL Server GUI
I’ve upgraded from SQL Server and it was a smooth change — Beekeeper Studio enhanced my own workstream, offering a cleaner experience and better performance, as well as flexibility. - Aman Bhattarai
Beekeeper Studio is a fast, intuitive and easy to use SQL Server client. It supports loads of other databases too, and works great on Windows, Mac and Linux.
What SQL Server Users Say About Beekeeper Studio
So far the most comprehensive DB admin GUI out there. The only reason I haven’t given 5 stars is I cannot claim to have used it exhaustively only having discovered it two weeks ago. But so far, mySQL, MSSQL and Postgres in one tool is simply incredible.
Planning to purchase once pay day hits.
I had been using the free version of Beekeeper studio for a while, but when I needed to work with some MongoDB databases I upgraded to the paid version. And honestly, I was up and running in no time. Beekeeper is slick, fast, and it just works. Very intuitive, very easy to use. I work with MongoDB, Postgresql, SQL Server, and other databases in my job, and having one tool that can talk to them all is just wonderful.
Thank you, Matthew and team!