This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
SQLDenis
About SQLDenis
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.Social Sitings
Summary
- Active from February 2008 to August 2013
- 597 posts published
Table of Contents
Posts
2013 (92 posts)
- Virtual book club.. who is in? on August 22, 2013
- Technical nepotism...do you suffer from it? on August 21, 2013
- When downloading a picture could cost you $100 on July 27, 2013
- If you think uninstalling SQL Server is a pain, have fun with Oracle on July 4, 2013
- Visual Studio 2013 Preview, Visual Studio 2012 Update 3 and .NET Framework 4.5.1 Now Available on June 26, 2013
- Download Windows 8.1 preview right now on June 26, 2013
- List of new programmability features/T-SQL enhancements in SQL Server besides Hekaton on June 25, 2013
- Supported and unsupported datatypes with Hekaton tables on June 25, 2013
- SQL Server 2014 CTP1 native compiled Hekaton procedures are faster than regular procedures on June 25, 2013
- New Dynamic Management Views in SQL Server 2014 CTP1 on June 25, 2013
- SQL Server 2014 CTP1 Available for download on June 25, 2013
- Yeah, I am sure that is the reason we have Oracle on Azure and Hyper-V now on June 24, 2013
- Nice Collection Of Free SQL Server, Visual Studio, Azure ebooks on June 19, 2013
- Checkout your twitter analytics from twitter itself on June 13, 2013
- SQL Puzzle.. How many uppercase and lowercase characters in a column on June 12, 2013
- Changing a column that is already populated into a column that uses a sequence on June 5, 2013
- SQL Puzzle.. Sorting results without using ORDER BY on June 5, 2013
- Happy 5th birthday LessThanDot! on June 1, 2013
- SQL Server 2012 System views poster available for download on May 31, 2013
- SQL Puzzle...how many even numbers are there in a row on May 29, 2013
- SQL Puzzle: RIGHT without using the RIGHT function on May 22, 2013
- SQL Server Database owner ~~UNKNOWN~~ on May 14, 2013
- Fixing a SQL Server could not spawn FRunCM thread error on April 30, 2013
- Windows Azure Training Kit April 2013 Released on April 29, 2013
- Where to find the xtype info for SQL Server in a table on April 26, 2013
- Using a Dedicated Administrator Connection via SSMS on April 7, 2013
- BCP all tables into files from a database on March 31, 2013
- Messing with your friendly DBA on April Fools' Day on March 29, 2013
- Little used SSIS tasks: Data Profiling Task on March 28, 2013
- Bring SQL Server databases Online or Offline when running on Amazon RDS on March 22, 2013
- Turning on Optimize for Ad hoc Workloads, Ad Hoc Distributed Queries and more on a AWS RDS SQL Server Instance on March 21, 2013
- How to read the error log on an Amazon RDS SQL Server instance on March 21, 2013
- Trying out Amazon Relational Database Service on March 21, 2013
- Creating a SQL Server Unique Index that behaves like an Oracle Unique Index on March 20, 2013
- MongoDB 2.4 Released on March 20, 2013
- Unique index difference between Oracle and SQL Server on March 19, 2013
- Using WITH RESULT SETS with stored procedures that return multiple resultsets on March 18, 2013
- Use WITH RESULT SETS to change column names and datatypes of a resultset on March 17, 2013
- Goodbye Google Reader, hello feedly on March 14, 2013
- Wrap inserts in a transaction for faster performance on March 13, 2013
- SQL Server 2012 Business Intelligence Whitepaper and Data Tools released on March 9, 2013
- Use the sp_describe_undeclared_parameters stored procedure to check if dynamic SQL has undeclared parameters on March 6, 2013
- Giving only insert permissions to a table for a new login on March 4, 2013
- Column name or number of supplied values does not match table definition when dealing with temp tables on March 3, 2013
- Pesky resolutions, the two month checkup on March 3, 2013
- Double the trouble in less than half the time on March 1, 2013
- Windows Azure Training Kit available on February 25, 2013
- An easier way to get SQL Server startup parameters: the sys.dm_server_registry dmv on February 24, 2013
- MongoDB: Using the web-based administrative tool on February 24, 2013
- Listing tables that are truly partitioned in SQL Server on February 23, 2013
- Suppressing xp_cmdshell output on February 21, 2013
- Ten things added after SQL Server 2000 that I like the most on February 18, 2013
- MongoDB: Returning documents where fields are null or not existing on February 17, 2013
- Listing all RESTORE and BACKUP operations currently going on your SQL Server on February 17, 2013
- BULK INSERT data where the row terminator is a linefeed in SQL Server on February 14, 2013
- Getting file size, space used and space free information for a SQL Server database on February 13, 2013
- An Oracle NULL/Blank gotcha when coming from SQL Server on February 10, 2013
- Discovering new things (for me) in SSMS on February 10, 2013
- SQL Server Support Windows Phone App released on February 9, 2013
- Getting the tables with the most rows from your database on February 8, 2013
- Listing all your SQL Server databases ordered by size on February 8, 2013
- Getting the biggest tables in your SQL Server database on February 8, 2013
- MongoDB: Creating capped collections on February 6, 2013
- MongoDB: How to drop databases and collections on February 5, 2013
- A couple of ways to convert an integer to an coordinate with SQL Server on February 3, 2013
- MongoDB: Exporting data into files on February 3, 2013
- MongoDB: How to backup all the databases with one command on February 1, 2013
- Umm....No...that is not how you export a table into a file with SQL Server on January 31, 2013
- MongoDB: How to restore collections on January 31, 2013
- MongoDB: How to backup and restore databases on January 30, 2013
- MongoDB: How to limit results and how to page through results on January 26, 2013
- How do you manage SQL Agent Jobs when using mirroring? on January 25, 2013
- MongoDB: How to include and exclude the fields you want in results on January 25, 2013
- Multidocument updates with MongoDB on January 20, 2013
- Indexes in MongoDB: A quick overview on January 19, 2013
- Displaying missing dates by utilizing a calendar table on January 17, 2013
- Does anyone use the NTILE() windowing function? on January 16, 2013
- MongoDB, how to sort results on January 16, 2013
- What is going on with Database Mail in SQL Server on January 15, 2013
- Database Mail maintenance in SQL Server on January 14, 2013
- Setting up SQL Server Database Mail with gmail on January 13, 2013
- Doing UPSERTs in MongoDB on January 12, 2013
- Scala: The difference between val and var on January 12, 2013
- Review of The Well-Grounded Java Developer on January 9, 2013
- Giving users the ability to change a stored procedure without making them db_owner on January 8, 2013
- Use the sys.database_mirroring DMV to quickly check if the databases are in principal or mirror role and what state they are in on January 7, 2013
- Truncate rollback differences between SQL Server and Oracle on January 6, 2013
- What is the Dual table in Oracle and why do I need it? on January 6, 2013
- Differences between Oracle and SQL Server when working with NULL and blank values on January 6, 2013
- Creating MongoDB as a service on Windows 8 on January 5, 2013
- Installing Scala 2.10 on Eclipse Juno on January 5, 2013
- Ah yes, those pesky resolutions on January 1, 2013
2012 (74 posts)
- 2012 Analytics about Devices, Operating Systems and Browsers on December 28, 2012
- 2012 Analytics about Searches, Countries and Content....... on December 27, 2012
- SQL Advent 2012: Recap on December 25, 2012
- SQL Advent 2012 Day 24: Getting help on December 24, 2012
- SQL Advent 2012 Day 23: Get the tools you need to be more productive on December 23, 2012
- D on December 23, 2012
- SQL Advent 2012 Day 22: Testing your backup and failover strategy on December 22, 2012
- SQL Advent 2012 Day 21: With VLDBs it matters what you do and how you do it on December 22, 2012
- SQL Advent 2012 Day 20: Use the new features on December 20, 2012
- SQL Advent 2012 Day 19: How to improve your tech skills on December 19, 2012
- SQL Advent 2012 Day 18: Stay relevant and marketable on December 19, 2012
- SQL Advent 2012 Day 17: No matter how long you are on the wrong path, go back on December 17, 2012
- SQL Advent 2012 Day 16: Lack of database design and normalization on December 16, 2012
- SQL Advent 2012 Day 15: Benefits of Indexes on December 15, 2012
- SQL Advent 2012 Day 14: When to say no on December 14, 2012
- SQL Advent 2012 Day 13: Features enabled that are not used on December 13, 2012
- SQL Advent 2012 Day 12: Proactive notifications on December 12, 2012
- SQL Advent 2012 Day 11: Cursors and loops on December 11, 2012
- SQL Advent 2012 Day 10: SQL Server Maintenance on December 10, 2012
- SQL Advent 2012 Day 9: Reinventing the wheel on December 9, 2012
- SQL Server Data Type Conversion Poster is available for download on December 8, 2012
- SQL Advent 2012 Day 8: Foreign Keys on December 8, 2012
- SQL Advent 2012 Day 7: Lack of constraints on December 7, 2012
- SQL Advent 2012 Day 6: Standardized Naming And Other Conventions on December 6, 2012
- SQL Advent 2012 Day 5: Do not trust the SSMS designers on December 5, 2012
- Dealing with the Column name 'TEXT()' contains an invalid XML identifier as required by FOR XML; '('(0x0028) is the first character at fault error on December 5, 2012
- SQL Advent 2012 Day 4: Triggers, what to do, what not to do on December 4, 2012
- SQL Advent 2012 Day 3: Sargable Queries on December 3, 2012
- SQL Advent 2012 Day 2: Data types storage differences on December 2, 2012
- SQL Advent 2012 Day 1: Sizing database files on December 1, 2012
- Java Training Day 5 on December 1, 2012
- Java Training Day 4 on November 29, 2012
- Java Training Day 3 on November 28, 2012
- Java Training Day 2 on November 28, 2012
- Java Training Day 1 on November 26, 2012
- SQL Advent 2012, here is what is coming on November 25, 2012
- Back to Java after an eleven year hiatus, what are some good resources you recommend? on November 25, 2012
- Find all the tables and indexes that have data compression on November 16, 2012
- SQL Server 2012 SP1 and in-memory OLTP DB Engine Hekaton announced on November 7, 2012
- Why do you need additional privileges for truncate table compared to delete? on October 7, 2012
- Are you a real programmer, do you know all these artifacts you should know according to Uncle Bob? on September 20, 2012
- How to name groups of tiles in Windows 8 on August 17, 2012
- How to shutdown windows 8 on August 17, 2012
- Windows 8, Visual Studio 2012 and Windows Server 2012 released to manufacturing on August 1, 2012
- SQL Server 2008 R2 SP2 Released on July 27, 2012
- E-Books in epu, mobi and pdf for Microsoft Technologies available for download on June 12, 2012
- OUTPUT Clause and @@identity, scope_identity() on May 25, 2012
- Backup to the cloud by using duplicati on May 24, 2012
- How to change the SA password in SQL Server on May 22, 2012
- Don't put a return statement in a stored procedure inside a transaction on May 18, 2012
- SQL Azure How To Rebuild A Clustered Index on May 3, 2012
- A couple of things to be aware of when working with tables in SQL Azure on May 2, 2012
- How to search for data with underscores or brackets in SQL Server? on May 2, 2012
- Review: Worm: The First Digital World War by Mark Bowden on April 22, 2012
- Would you be interested in an information section for SQLCop? on April 9, 2012
- Please don't use blacklists, use parameterized queries or stored procs instead on April 5, 2012
- Downloading SQL Server Sample Databases much improved with new CodePlex changes on April 3, 2012
- Dammit people, get to know check constraints and use them! on April 3, 2012
- You don't need to shrink a database to get a smaller backup on March 31, 2012
- Is your Apache Server Status wide open for the world to see? on March 22, 2012
- How to give permissions to User-Defined Table Types on March 21, 2012
- New 100MB database option and lower pricing across the board for SQL Azure on February 14, 2012
- Getting the list of parameters from a stored procedure by using sqlCmd.Parameters or INFORMATION_SCHEMA.parameters on February 14, 2012
- Difference between a cross join and a full outer join on February 12, 2012
- Firefox heading for 15% market share? on February 11, 2012
- How I use PowerShell to generate table output for blog posts from query results on January 19, 2012
- How to connect to SQL Server when your default database is unavailable on January 14, 2012
- Four Windows Phone Starter Kits Available on January 14, 2012
- Friday SQL Nugget #1 post on January 13, 2012
- Meme Monday: what is the first blogpost you wrote and when did you write it? on January 9, 2012
- The Thank You Economy by Gary Vaynerchuk on January 7, 2012
- SQL Azure Compatibility Assessment service released on January 4, 2012
- Scripting data in SQL Server 2012 on January 2, 2012
- Make 2012 the year that you will learn how to code on January 1, 2012
2011 (106 posts)
- 2011 A look back with some stats on December 30, 2011
- SQL Advent 2011: What is coming in SQL Server 2012? on December 26, 2011
- SQL Advent 2011 Recap on December 25, 2011
- SQL Advent 2011 Day 24: Index REBUILD and REORGANIZE on December 24, 2011
- Upgrade Assistant for SQL Server 2012 available for download on December 23, 2011
- SQL Advent 2011 Day 23: OBJECT_DEFINITION on December 23, 2011
- SQL Advent 2011 Day 22: Dynamic Management Views on December 22, 2011
- SQL Advent 2011 Day 21: TRY CATCH on December 21, 2011
- SQL Advent 2011 Day 20: Indexes with Included Columns on December 21, 2011
- SQL Advent 2011 Day 19: Filtered Indexes on December 19, 2011
- SQL Advent 2011 Day 18: Table-valued Parameters on December 18, 2011
- SQL Advent 2011 Day 17: varchar(max) on December 17, 2011
- SQL Advent 2011 Day 16: CROSS APPLY and OUTER APPLY on December 16, 2011
- SQL Advent 2011 Day 15: Joins on December 16, 2011
- SQL Advent 2011 Day 14: EXCEPT and INTERSECT SET Operations on December 15, 2011
- SQL Advent 2011 Day 13: DDL Triggers on December 13, 2011
- SQL Advent 2011 Day 12: Table Value Constructor on December 12, 2011
- SQL Advent 2011 Day 11: DML statements with the OUTPUT clause on December 11, 2011
- SQL Advent 2011 Day 10: Upsert by using the Merge statement on December 10, 2011
- Silverlight 5 available for download, will it be the last version? on December 10, 2011
- SQL Advent 2011 Day 9: Dynamic TOP on December 9, 2011
- SQL Advent 2011 Day 8: UNPIVOT on December 8, 2011
- SQL Advent 2011 Day 7: Crosstab with PIVOT on December 7, 2011
- SQL Advent 2011 Day 6: Windowing functions on December 6, 2011
- SQL Advent 2011 Day 5: Common Table Expressions on December 5, 2011
- SQL Advent 2011 Day 4: Schemas on December 4, 2011
- SQL Advent 2011 Day 3: Partitioning on December 3, 2011
- How to call a user defined function with a default parameter on December 2, 2011
- SQL Advent 2011 Day 2: system tables and catalog views on December 2, 2011
- How to capture the error output from a stored procedure when calling another stored procedure in SQL Server? on December 1, 2011
- SQL Advent 2011 Day 1: Date and time on December 1, 2011
- Anecdotes about SQL AKA post 400 on November 30, 2011
- Are you ready for SQL Server 2012 or are you still partying like it is 1999? on November 27, 2011
- Showing sysjobhistory run_duration in HHMMSS format on November 17, 2011
- Location of files for new database in SQL Server on November 17, 2011
- SQL Server 2012 RC0 available for download on November 17, 2011
- List all stored procedures that run at startup in SQL Server on November 15, 2011
- A trip down technology memory lane on October 29, 2011
- What does a SQL Server DBA need to check for daily, weekly, monthly, quarterly and yearly? on October 18, 2011
- Ghost in the wires by Kevin Mitnick a review on October 15, 2011
- SQL Server 2012 to be released Q1 2012 on October 12, 2011
- Ada Lovelace Day..Do you remember which women have influenced you over the years? on October 7, 2011
- SQL Server 2008 Service Pack 3 has been released on October 6, 2011
- Returning a value inserted in a table with a newsequentialid() default on a uniqueidentifier column on September 23, 2011
- Review of In The Plex: How Google Thinks, Works, and Shapes Our Lives by Stephen Levy on September 23, 2011
- Don't fall for the social engineering scam that makes you go to ammyy.com on September 18, 2011
- You need to have hardware virtualization enabled if you want to run Windows 8 in Virtual Box on September 14, 2011
- Windows 8 Developer Preview with tools available for download on September 13, 2011
- Google realizes that JavaScript is a dead end programming language, to be replaced by Dart a new language on September 11, 2011
- Use common table expressions to simplify your updates in SQL Server on September 10, 2011
- How much longer will the SQL Server database restore take on September 2, 2011
- Microsoft SQL Server, codename "Denali", will be the last release to support OLE DB, ODBC is the new new thing on August 30, 2011
- SQL Server Code Name "Denali" CTP3 Product Guide available for download on August 10, 2011
- Review of Zero Day by Mark Russinovich on August 7, 2011
- SQL Injection Pocket Reference for MySQL, SQL Server and Oracle on July 29, 2011
- How to find what column caused the String or binary data would be truncated message on July 27, 2011
- TRY_CONVERT in SQL Server Denali CTP3 on July 19, 2011
- SQL Server Columnstore Index FAQ wiki page published on July 15, 2011
- Format function in SQL Server Denali CTP3 on July 15, 2011
- Concat function in SQL Server Denali CTP3 on July 15, 2011
- ColumnStore Index limitations in SQL Server Denali CTP3 on July 14, 2011
- DATEFROMPARTS and DATETIMEFROMPARTS functions in SQL Server Denali CTP3 on July 13, 2011
- A Quick look at the new EOMONTH function in SQL Server Denali CTP3 on July 13, 2011
- A Quick look at the new IIF function in Denali CTP3 on July 13, 2011
- SQL Server Code Name "Denali" CTP3 is available for download on July 12, 2011
- I hold this blog hostage for 1 million views mahaaahaha mahahaha.... on July 5, 2011
- What I have read so far this year on July 3, 2011
- LulzSec has shut down, has ended hacking campaign on June 26, 2011
- Compressing files with NTFS compression by running compact from the command line on June 22, 2011
- HTML5 Support for the Visual Studio 2010 Editor available for download on June 16, 2011
- Do you care that SQL Server Denali cannot be installed on Windows XP? on June 15, 2011
- Review: Physics of the Future: How Science Will Shape Human Destiny and Our Daily Lives by the Year 2100 by Michio Kaku on June 12, 2011
- A week in Sybase Training, what did I learn, day 5 on June 10, 2011
- A week in Sybase Training, what did I learn, day 4 on June 9, 2011
- A week in Sybase Training, what did I learn, day 3 on June 8, 2011
- A week in Sybase Training, what did I learn, day 2 on June 7, 2011
- A week in Sybase Training, what did I learn, day 1 on June 6, 2011
- Book review: Quantum Man: Richard Feynman's Life in Science on June 5, 2011
- Do you still use sp_change_users_login instead of ALTER USER UserName WITH LOGIN = UserName on June 3, 2011
- Bing, Google and Yahoo! announce Schema.org on June 2, 2011
- First look at the windows 8 UI on June 1, 2011
- Less Than Dot is three years old, here are some stats on June 1, 2011
- Data Quality and Master Data Management with Microsoft SQL Server 2008 R2 book available as a free download on June 1, 2011
- Book Review: Securing SQL Server By Denny Cherry on May 27, 2011
- Watch all the Tech·Ed North America 2011 SQL Server videos on May 19, 2011
- Raise your hand if you have seen code that sends email from within a trigger in SQL Server on May 11, 2011
- Match your defaults with your trigger values to prevent horrible fragmentation on your indexes and tables on May 6, 2011
- SQL Server 2008 R2 SP1 CTP Available for download on April 22, 2011
- Use DDL Triggers To Track Table Changes on April 21, 2011
- Silverlight 5 Beta Is Available For Download on April 13, 2011
- First Look at IE 10 on April 12, 2011
- When changing column data types use ALTER TABLE TableName ALTER Column syntax, don't drop and recreate column on April 10, 2011
- Be careful when passing around parameters, make sure they are the same size and type on April 8, 2011
- What does the lock icon mean in SSMS when looking at a stored procedure? on April 6, 2011
- Use a database how it was intended to be used on April 4, 2011
- Use the GROUPING function to determine whether a value is NULL because of ROLLUP on March 23, 2011
- Do you have Chimney Offload State disabled? on March 18, 2011
- Visual Studio 2010 Service Pack 1 released on MSDN on March 8, 2011
- T-SQL Tuesday #016 Grouping Market Data With T-SQL on March 8, 2011
- Learn the platform differences to be more effective on March 7, 2011
- New Collection of SQL Server Videos on Channel 9 on March 5, 2011
- What does a SQL Server developer need to know? on February 21, 2011
- Latest article by SQL Server MVP Erland Sommarskog is a gem on February 21, 2011
- Windows 7 SP1 RTM available for MSDN and TechNet customers on February 16, 2011
- Trapping errors when working with linked servers on February 15, 2011
- Using Database Snapshot As A Protection Against Rogue Deletes on February 2, 2011
2010 (82 posts)
- 2010 stats: most popular posts, search keywords and countries on December 31, 2010
- Review of my 2010 goals on December 29, 2010
- 2010.. a year in stats..browsers, smartphones and windows flavors on December 23, 2010
- How to move datafiles to a new drive in SQL Server on December 17, 2010
- Dealing with The row value(s) updated or deleted either do not make the row unique or they alter multiple rows errors on December 8, 2010
- SQL Server Denali CTP1 Announced at PASS on November 9, 2010
- The new Dynamic Management Views in SQL Server Denali on November 9, 2010
- Playing around with sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_object on November 9, 2010
- Don't install Denali BIDS side by side with a 2008 instance on November 9, 2010
- Find what is deprecated in SQL Server Denali by using sys.dm_os_performance_counters on November 9, 2010
- Using OFFSET N ROWS FETCH NEXT N ROWS ONLY In SQL Server Denali for easy paging on November 9, 2010
- Debugging In SQL Server Denali on November 9, 2010
- Screenshots of the new look and feel of BIDS in Denali on November 9, 2010
- A first look at sequences in SQL Server Denali on November 9, 2010
- First look at SQL Server Management Studio Denali on November 9, 2010
- What SQL Server book would you recommend for a Sybase and Oracle admin? on November 8, 2010
- Use an OUTER LOOP JOIN for faster performance when one of the tables is much smaller on November 5, 2010
- Tokenizing filenames in SQL Server on October 20, 2010
- How to flip a bit in SQL Server by using the Bitwise NOT operator on September 29, 2010
- SQL Server 2008 Service Pack 2 Released on September 29, 2010
- Patch for the ASP.NET Padding Oracle vulnerability has been released on September 28, 2010
- How to capture the error output from xp_cmdshell in SQL Server on September 22, 2010
- When should you store @@ROWCOUNT into a variable? on September 10, 2010
- Dealing with The multi-part identifier "dbo.Table.Column" could not be bound. error in an update statement on September 1, 2010
- Searching for ranges when you have quarters and years on August 25, 2010
- Post 300 or why all developers should be blogging on August 21, 2010
- Misconceptions about unicode in SQL Server on August 7, 2010
- How to return only weekend data for the last 4 weeks in SQL Server on August 6, 2010
- SQLCop A Tool To Highlight Potential Problems With Your Database on July 25, 2010
- MSDN giveaway winners on July 9, 2010
- Final vote for the MSDN giveaway on July 9, 2010
- Vote for the MSDN giveaway winner on July 8, 2010
- MSDN Ultimate Subscription giveaway on July 3, 2010
- Visual Studio 2010 and .NET Framework 4 Training Kit June 2010 Release Available on June 20, 2010
- Checking for NULL values in all columns that allow NULLS in all the tables on June 16, 2010
- How to clean a table from badly named column names on June 11, 2010
- How to refresh the local IntelliSense cache in SQL Server Management Studio on June 5, 2010
- Error: The GetBytes function can only be used on columns of type Text, NText, or Image on June 3, 2010
- Less Than Dot is two years old, here are some stats on June 1, 2010
- Has FireFox lost its Mojo, are FireFox user jumping ship to Chrome? on May 26, 2010
- Three different ways of populating variables with configuration values in SQL Server on May 19, 2010
- How to use T-SQL to get the command line startup parameters that were used to start SQL Server on May 18, 2010
- How to get the processid that SQL Server is using if you have multiple instances of SQL Server running on May 12, 2010
- SQL Meme: Tagged: 5 things SQL Server should drop on May 11, 2010
- SSIS A difference between C# and VB in a script task on May 3, 2010
- How to insert values into a table with only an identity column on April 30, 2010
- Debugging 64 bit SSIS packages on April 25, 2010
- SQL Saturday New York City recap on April 25, 2010
- Do you use disable index or drop index when running your ETL processes in SQL Server on April 21, 2010
- Do you use Column=@Param OR @Param IS NULL in your WHERE clause? Don't, it doesn't perform on April 15, 2010
- Visual Studio 2010 and Microsoft .NET Framework 4 Available for download today on April 12, 2010
- MongoDB vs. SQL Server – INSERT comparison part deux on April 6, 2010
- Getting the physical device name and backup time for a SQL Server database on April 2, 2010
- Interview with me about the chapters I wrote for the SQL Server Deep Dives book on March 26, 2010
- Formatting the time from a datetime or time datatype by using the STUFF function on March 24, 2010
- A quick look at Windows Phone 7 development on March 21, 2010
- Internet Explorer 9 available for a test drive on March 16, 2010
- Visual Studio 2010 Concurrency Profiling And Parallel Programming on March 14, 2010
- ASP.NET MVC 2 RTM for Visual Studio 2008 SP1 Released on March 11, 2010
- Do You Get A Benefit From Compressing Backups If You Already Have Compressed Data? on March 2, 2010
- Running sp_helpdb against a snapshot shows wrong files on SQL Server 2008 on February 11, 2010
- If you are suffering from Cisco VPN on 64 bit Windows then use the Shrew Soft VPN client on February 11, 2010
- Visual Studio 2010 and .NET 4 release candidates available for download on February 9, 2010
- Use Filters in SSMS to only see the things that are of interest to you on February 6, 2010
- Interesting UNION with ORDER BY behavior on February 5, 2010
- ASP.NET MVC 2 (Release Candidate 2) Released on February 5, 2010
- Windows Azure Tools for Microsoft Visual Studio 1.1 Released on February 2, 2010
- Running static code analysis on SQL Server database with Visual Studio Team System for database architects on January 31, 2010
- Use sys.dm_os_performance_counters to get your Buffer cache hit ratio and Page life expectancy counters on January 22, 2010
- Use alter table alter column to change datatypes for a column in SQL Server on January 19, 2010
- SQL Server 2008 R2 to be released in May on January 19, 2010
- How to return all the skipped identity values from a table in SQL Server on January 18, 2010
- Setting up SQL Server with ASP.NET MVC on January 17, 2010
- Find Out If You Are Using Deprecated Features In SQL Server 2008 on January 14, 2010
- Interview with Brent Ozar about the book Professional SQL Server 2008 Internals and Troubleshooting on January 13, 2010
- Find Out What Percent Of The Log Is Being Used For Each Database In SQL Server 2005 and 2008 on January 13, 2010
- Microsoft Announces SQL Server Migration Assistant for MySQL on January 12, 2010
- 2010 Goals For SQLDenis on January 12, 2010
- Daemon by Daniel Suarez is a book every programmer will love on January 6, 2010
- SQL Azure CTP Testers Can Upgrade Their Accounts To Paid Commercial Subscriptions Starting Today on January 4, 2010
- How To Enable GodMode On Windows 7 on January 3, 2010
- The most read posts and most searched keywords for 2009 on LessThanDot in 2009 on January 2, 2010
2009 (139 posts)
- How To Modify The Host File In Windows 7 Or Vista on December 29, 2009
- My top ten favorite technologies of this decade. on December 28, 2009
- Visual Studio 2010 Beta 2 Virtual Machines with Sample Data Available on December 26, 2009
- Testing backup compression in SQL Server 2008 on November 22, 2009
- Best Practice: Coding SQL Server triggers for multi-row operations on November 12, 2009
- SQL Server 2008 R2 November CTP Available For Download on November 9, 2009
- SQL Server 2008 R2 Editions Pricing Announced on November 6, 2009
- SQL Server 2008 R2 Datacenter and SQL Server 2008 R2 Parallel Data Warehouse Editions Announced on November 3, 2009
- If you want to learn about Google Wave then check out the book The Complete Guide to Google Wave on November 2, 2009
- Oracle Details Its Plans For MySQL, Java, Virtualization, NetBeans, Glassfish, OpenOffice And Open Source on October 31, 2009
- Interesting Increase Key Value Post By CSS SQL Server Engineers on October 26, 2009
- Dealing with Cannot resolve collation conflict for equal to operation errors on October 26, 2009
- Windows 7 Launch In New York City on October 23, 2009
- Visual Studio 2010 and .NET Framework 4 Beta 2 Available on MSDN on October 19, 2009
- Win A Copy Of SQL Server 2008 Administration in Action on October 13, 2009
- Interview With Rod Colledge About The Book SQL Server 2008 Administration in Action on October 12, 2009
- T-SQL To find Out If An Index Is Clustered Or Non Clustered on October 6, 2009
- Do we need to know basic math as programmers? on October 5, 2009
- Calculating The Percentage Of Null Values In A Column With Transact SQL on October 2, 2009
- Five Google Wave Invitations are up for grabs on October 1, 2009
- Microsoft Security Essentials, available for download tomorrow on September 28, 2009
- Review of SQL Server 2008 Administration in Action on September 28, 2009
- SQL Server MVP Deep Dives a book written by SQL Server MVPs supporting a good cause on September 25, 2009
- Use INDEXKEY_PROPERTY in SQL Server to determine if columns in indexes are sorted ascending or descending on September 23, 2009
- How I got started with SQL Server on September 7, 2009
- Learn About SQL Server 2008 R2 Project Gemini And Project Madison By Watching These Videos on September 1, 2009
- SSMS Tools PACK, Something Every SQL Server Developer That Uses SSMS Should Have Installed on August 30, 2009
- Scripting all jobs on SQL Server 2005/2008 into one file on August 23, 2009
- SQL Server StreamInsight CTP2 Available For Download on August 22, 2009
- Scripting All The Jobs On Your SQL Server Instance Into Separate Files By Using SMO on August 18, 2009
- SQL Server 2008 R2 August Community Technology Preview (CTP) Announced on August 10, 2009
- SQL Server sprawl, heard it twice in one day on August 5, 2009
- Finding Out How Many Times A Table Is Being Used In Ad Hoc Or Procedure Calls In SQL Server 2005 And 2008 on August 3, 2009
- When Books On Line is not really correct on July 24, 2009
- Highly Critical Adobe Reader/Acrobat SWF Content Arbitrary Code Execution Vulnerability on July 23, 2009
- Windows 7 and Windows Server 2008 R2 Released To Manufacturing on July 22, 2009
- Dealing with the could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT error message on July 21, 2009
- The differences between LEN and DATALENGTH in SQL Server on July 20, 2009
- Ecofont, Will this save the planet? on July 17, 2009
- Operand type clash: date is incompatible with int error when trying to do +1 on a date data type in SQL Server 2008 on July 15, 2009
- Windows Azure, SQL Azure and .NET Services pricing announced on July 14, 2009
- Messing around with Office 2010, I like what I see on July 14, 2009
- Vulnerability in Microsoft Office Web Components control could allow remote code execution on July 13, 2009
- A couple of ways of getting the top 2 distinct values from a set in SQL Server on July 8, 2009
- Vulnerability in Microsoft Video ActiveX control could allow remote code execution on July 8, 2009
- How to copy data/append data into files from within T-SQL on July 6, 2009
- How To Script Out The Whole Database In SQL Server 2005 and SQL Server 2008 on July 1, 2009
- Adding time offsets passed in to a datetime to generate localized datetime on June 26, 2009
- Can't depend on sp_depends? Try using sp_refreshsqlmodule on June 26, 2009
- Replace Your Case When Then Else Syntax With the Sign Function In SQL Server on June 22, 2009
- Use FOR XML AUTO,TYPE, ELEMENTS to get XML in the format you really want with SQL Server FOR XML Syntax on June 19, 2009
- How to Install Internet Information Services (IIS) On Windows 7 on June 18, 2009
- Having Fun With OPENQUERY And Update,Delete And Insert Statements on June 17, 2009
- Dealing with A transport-level error has occurred when sending the request to the server errors on June 17, 2009
- Listing All The User-Defined Data Types That Were Created On Your SQL Server on June 16, 2009
- Review Of Beginning Spatial With SQL Server 2008 on June 15, 2009
- Bing, worth switching from Google? on June 15, 2009
- How to mount ISO images on Vista or Windows 7 on June 14, 2009
- Optional and named arguments in C# a comparison with SQL Server stored procs on June 12, 2009
- Avoid Conversions In Execution Plans By Using sp_executesql Instead of Exec on June 10, 2009
- Changing exec to sp_executesql doesn't provide any benefit if you are not using parameters correctly on June 9, 2009
- Enabling ReadyBoost In Vista on June 7, 2009
- Your testbed has to have the same volume of data as on production in order to simulate normal usage on June 2, 2009
- Less Than Dot A Year In Review on June 1, 2009
- Grouping datetime values in half hour blocks in SQL Server on May 29, 2009
- Vulnerability in DirectX Could Allow Remote Code Execution on May 29, 2009
- Is an index seek always better or faster than an index scan? on May 26, 2009
- SQL Server does support regular expressions in check constraints, triggers are not always needed on May 26, 2009
- Here Is Yet Another Reason For Upgrading To SQL Server 2008 From SQL Server 2000 on May 22, 2009
- SQL Server 2008 Developer Training Kit Available For Download on May 21, 2009
- Vulnerability in IIS Could Allow Elevation of Privilege on May 20, 2009
- Visual Studio 2010 Screenshots on May 19, 2009
- Microsoft bans memcpy() to minimize buffer overflows on May 18, 2009
- SQLCop, FxCop For SQL Server, Would You Be Interested in This? on May 15, 2009
- SQL Server 2008 R2 Announced, CTP Coming This Summer on May 12, 2009
- Creating A XSD Schema From A Table In SQL Server With FOR XML Syntax on May 11, 2009
- Banish IE6? Not As Easy As You Think on May 11, 2009
- Some PostgreSQL Announcements on May 8, 2009
- Microsoft Enterprise Developer Conference Overview on May 7, 2009
- SQL Rap: I am the DBCC, yeah u know me on May 1, 2009
- How to import a bunch of XML files from a directory in T-SQL on April 28, 2009
- How To Disable Autogenerated Comments When You Script Out Objects on April 28, 2009
- How to pad positive and negative number with zeroes in SQL Server? on April 24, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 18 on April 17, 2009
- Troubleshooting Performance Problems in SQL Server 2008 White Paper Released on April 15, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 17 on April 10, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 16 on April 3, 2009
- Answers To The SQL Server Quiz: Can You Answer All These Post on March 26, 2009
- SQL Server Quiz, Can You Answer All These? on March 25, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 15 on March 20, 2009
- MIX09, SilverLight 3, Expression Blend 3, IE8, ASP.NET MVC 1.0 And Much More on March 19, 2009
- ASP.NET MVC 1.0 Has Been Released on March 18, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 14 on March 13, 2009
- Patterns And Practices Application Architecture Guide 2.0, Something Everyone Should Read on March 12, 2009
- Free ASP.NET MVC eBook Tutorial in pdf format on March 11, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 14 on March 6, 2009
- Create XML Files Out Of SQL Server With SSIS And FOR XML Syntax on March 5, 2009
- ASP.NET MVC Release Candidate 2 Has Been Released on March 3, 2009
- Collection Of Puzzles For Programmers on March 2, 2009
- FireFox, Chrome and Internet Explorer 8 Memory Usage, IE8 Uses More Memory Than Chrome and FireFox Combined on March 2, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 13 on February 27, 2009
- Learn Visual Studio 2010 now by watching these videos on February 23, 2009
- Podcasts I Listen To on February 22, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 12 on February 20, 2009
- How To Name Default Constraints And How To Drop Default Constraint Without A Name In SQL Server on February 18, 2009
- What was your first computer and what were some of your favorite games? on February 17, 2009
- Debian GNU/Linux 5.0 Lenny released on February 15, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 11 on February 13, 2009
- SQL Server 2008 Proximity Search With The Geography Data Type on February 11, 2009
- Kaspersky Web Site Hacked With SQL Injection, How Embarrassing Is This? on February 10, 2009
- Suppress string or binary data would be truncated messages with the ANSI WARNINGS setting on February 9, 2009
- Review of Pro SQL Server 2008 Relational Database Design and Implementation on February 7, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 10 on February 6, 2009
- An Interview With Kevin Kline About SQL In A Nutshell Third Edition on February 4, 2009
- Key Feature list For All the Different Windows 7 Versions on February 3, 2009
- Kaxaml a lightweight XAML editor on February 3, 2009
- SQL Server 2008 Books Online Jan, 2009 download now available on February 2, 2009
- How to enable xp_cmdshell and Ad Hoc Distributed Queries on SQL Server 2005 on February 1, 2009
- Magnolia crashed data corruption and loss on January 31, 2009
- Has Google Been Hacked? Every search result shows This site may harm your computer. on January 31, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 9 on January 30, 2009
- ASP.NET MVC 1.0 Release Candidate Now Available For Download on January 29, 2009
- Cool Way To Launch The Malicious Software Removal Tool on January 29, 2009
- how to make sure that the view will have the underlying table changes by using sp_refreshview on January 28, 2009
- VMware Powershell VI Toolkit 1.5 Released for Windows with 32 new cmdlets on January 28, 2009
- Internet Explorer 8 Release Candidate 1 Available For Download on January 26, 2009
- PerformancePoint Server To Become PerformancePoint Services In SharePoint Server on January 23, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 8 on January 23, 2009
- X# a domain specific language designed to quickly create Web applications and services on January 21, 2009
- Win32/Conficker.B also known as Downadup worm infections warning on January 20, 2009
- Do you use Metasploit to check if your servers are vulnerable? on January 20, 2009
- How to implement a typeof operator in SQL by using sql_variant_property on January 16, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 7 on January 16, 2009
- Return all the columns in the database which allow NULLS on January 14, 2009
- The Most Used Words On Our Blog on January 9, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 6 on January 9, 2009
- The SQL Server Memory Leak Confusion on January 7, 2009
- Site is no more after they discover they did not have SQL Server backups on January 4, 2009
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 5 on January 2, 2009
2008 (104 posts)
- My to-do list for 2009 on December 30, 2008
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 4 on December 26, 2008
- Want To Learn Scrum? Visit About Scrum. on December 24, 2008
- sp_replwritetovarbin Heap Overflow Code Exploit Code In The Wild, Works By Using Our Good Friend SQL Injection on December 23, 2008
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 3 on December 19, 2008
- SQL Server 2005 Service Pack 3 has been released on December 15, 2008
- IronPython 2.0 has been released, now runs on top of the Dynamic Language Runtime (DLR) on December 12, 2008
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 2 on December 12, 2008
- CHESS: An Automated Concurrency Testing Tool on December 11, 2008
- The Ten Most Asked SQL Server Questions And Their Answers on December 10, 2008
- Financial Functions for .NET released on December 6, 2008
- SQL Friday, The Best SQL Server Links Of The Past Week Episode 1 on December 5, 2008
- Failed to access IIS metabase or why it is important to do things in the correct order on December 4, 2008
- sqltrace: A Tool Every SQL Server Developer Should Have on December 3, 2008
- SQL Server Application and Multi-Server Management Private CTP on December 2, 2008
- SQL Server 2008 Upgrade Technical Reference Guide Available For Download on November 26, 2008
- Cumulative update package 2 for SQL Server 2008 is available on November 19, 2008
- SQL Server Fabric and DATAllegro demo at PASS, SQL Data Services Public CTP Available on November 19, 2008
- Cumulative Update 1 to the RML Utilities for Microsoft SQL Server Released on November 12, 2008
- What is wrong with this code? on November 12, 2008
- Visual Studio 2010 and the .NET Framework 4.0 Week, 12 videos on Channel 9 on November 10, 2008
- Finding Fragmentation Of An Index And Fixing It on November 7, 2008
- Windows Server 2008 R2 Will Support 256 Logical Processors on November 6, 2008
- Free Microsoft Chart Controls for Microsoft .NET Framework 3.5 on November 6, 2008
- Create a sorted view in SQL Server 2005 and SQL Server 2008 on November 5, 2008
- Windows Azure From A Developer's Perspective Post on November 4, 2008
- Windows Server 2008 R2 is the first Windows OS platform to go 64-bit only on October 31, 2008
- SQL Server 2005 Service Pack 3 – Beta Available For Download on October 31, 2008
- Microsoft SQL Server 2008 Feature Pack October 2008 Available For Download on October 30, 2008
- .NET Framework 4 Poster In PDF and DeepZoom Formats on October 30, 2008
- Can't go to PDC 2008, watch the videos on Channel 9 and on the PDC 2008 site on October 29, 2008
- The new features in C# 4.0 on October 28, 2008
- Azure Services Platform Is In CTP on October 27, 2008
- Dependency Injection Tool StructureMap 2.5 Has Been Released on October 27, 2008
- Flash Player 10 has been released on October 15, 2008
- OpenOffice 3.0 is now available on October 13, 2008
- Microsoft releases Silverlight 2 announces development capabilities with Eclipse on October 13, 2008
- Will Silverlight 2 Be RTM Tomorrow? on October 12, 2008
- FILESTREAM Storage in SQL Server 2008 Technical Article on October 10, 2008
- The Manga Guide to Databases on October 8, 2008
- Google Interview Questions on October 8, 2008
- SSMS Tools PACK 1.1 – now with SQL Server Management Studio 2008 support on October 7, 2008
- Mono 2.0 Has Been Released on October 7, 2008
- Kilimanjaro is the code name for the next version of SQL Server on October 6, 2008
- Npgsql2 the PostgreSQL Net Data provider written 100% in C# has been released on October 6, 2008
- How To Convert IP Addresses Between Bigint and Varchar on October 5, 2008
- Free SQL Server Books on October 5, 2008
- Poll: Which of the following SQL Server features do you use? on October 3, 2008
- Run Microsoft Windows Server And SQL Server in the cloud on Amazon EC2 on October 1, 2008
- Review of MCTS Self-Paced Training Kit (Exam 70-502): Microsoft .NET Framework 3.5 Windows Presentation Foundation on September 30, 2008
- Microsoft Unveils Next Version of Visual Studio and .NET Framework: Visual Studio 2010 and the .NET Framework 4.0 on September 29, 2008
- jQuery will ship with ASP.NET MVC and Visual Studio! on September 29, 2008
- SQL Server 2008 Cumulative Update 1 is available from Microsoft on September 23, 2008
- ISO Week In SQL Server on September 22, 2008
- Interview With Louis Davidson Author of Pro SQL Server 2008 Relational Database Design and Implementation on September 18, 2008
- Nice .NET Design Patterns Articles on September 17, 2008
- Google Chrome Dev Channel: Early Access to Features and Fixes on September 16, 2008
- DATAllegro acquisition to enable SQL Server to scale into hundreds of terabytes of data on September 16, 2008
- FIX for A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key bug on September 16, 2008
- One Second Caching, Brilliant Or Insane? on September 14, 2008
- What is deferred name resolution and why do you need to care? on September 8, 2008
- F# Developer Center on September 5, 2008
- Get A Free SQL Server 2008 Ebook on September 4, 2008
- Django 1.0 Released on September 4, 2008
- Stats For The Last Three Months on September 2, 2008
- WPF Performance Profiling Tools on September 1, 2008
- Find Out The Recovery Model For Your Database on August 30, 2008
- How to Rebuild System Databases in SQL Server 2008 on August 29, 2008
- LINQ to SQL queries involving strings cause SQL Server procedure cache bloat on August 28, 2008
- SQL Server 2008 Express with Advanced Services And SQL Server 2008 Express With Tools Now Available For Download on August 26, 2008
- How Do You Check If A Temporary Table Exists In SQL Server on August 22, 2008
- Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code on August 17, 2008
- .NET Framework 3.5 SP1: LINQ perf improvements (LINQ to Objects and LINQ to SQL) on August 12, 2008
- ISO-11179 Naming Conventions on August 11, 2008
- Microsoft SQL Server 2008 Feature Pack, August 2008 Available for download on August 7, 2008
- SQL Server 2008 cannot be installed if you have Visual Studio 2008 RTM installed on August 7, 2008
- Getting The Percentage Of NULLS And Values In A SQL Server Table on August 5, 2008
- How Are Dates Stored In SQL Server? on August 4, 2008
- How Does Between Work With Dates In SQL Server? on August 1, 2008
- Converting Columns To Date From Datetime Does Not Result In A Scan In SQL Server 2008 on July 24, 2008
- 5 Books Every Developer Should Read on July 20, 2008
- SQL Server 2008 geography data type screencasts on Channel 9 on July 19, 2008
- Vulnerabilities in Microsoft SQL Server Could Allow Elevation of Privilege on July 8, 2008
- sp_indexinfo an enhanced index information procedure on July 7, 2008
- An Introduction to New T-SQL Programmability Features in SQL Server 2008 on July 7, 2008
- Sybase IQ Is A Columnar Database, Why Should I Care? on June 27, 2008
- Use The XSS (Cross Site Scripting) Cheat Sheet To Check Your Site For Cross Site Scripting Attacks on June 26, 2008
- Microsoft Has Released Tools To Address SQL Injection Attacks on June 25, 2008
- How To Restart A Remote Computer on June 24, 2008
- Three Ways To Return All Rows That Contain Uppercase Characters Only on June 24, 2008
- How to rename a column in a SQL Server table without using the designer on June 23, 2008
- You may receive an error message, or the computer may stop responding, when you host Web applications that use ASP.NET on a computer that is running Windows Server 2003 on June 18, 2008
- Compound Operators Or How T-SQL Is Morphing Into VB Or C# on June 12, 2008
- SQL Server 2008 Adds ISO Week,TZoffset, Nanosecond And Microsecond To Datepart on June 12, 2008
- SQL Server 2008 Release Candidate 0 Available To The General Public on June 10, 2008
- Do you have any questions for Paul Nielsen or Louis Davidson on June 10, 2008
- SQL Server 2008 Release Candidate 0 Available For Download on June 6, 2008
- OPENROWSET And Excel Problems on June 5, 2008
- Podcast: SQL Server 2008 Security and Availability, Management, Troubleshooting and Throttling on June 4, 2008
- SQL Server 2008 Logo on June 3, 2008
- Microsoft Source Analysis for C# Announced on May 23, 2008
- Good SQL Articles To Read If You Can't Afford Books on May 23, 2008
- How to get the selectivity of an index on May 20, 2008
- Review of Inside Microsoft SQL Server 2005 Query Tuning and Optimization on February 8, 2008