SQLDenis

About the Author

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

• Total posts: 577
• Total views: 2305955
• Average views per post: 3,996.46
• Total comments: 1571
• Average comments per post: 2.72

• SQL Puzzle: RIGHT without using the RIGHT function (Views: 577, Comments: 7)
• SQL Server Database owner ~~UNKNOWN~~ (Views: 7232, Comments: 0)
• Fixing a SQL Server could not spawn FRunCM thread error (Views: 11225, Comments: 0)
• Windows Azure Training Kit April 2013 Released (Views: 1446, Comments: 0)
• Where to find the xtype info for SQL Server in a table (Views: 10587, Comments: 2)
• Using a Dedicated Administrator Connection via SSMS (Views: 11970, Comments: 1)
• BCP all tables into files from a database (Views: 11475, Comments: 0)
• Messing with your friendly DBA on April Fools' Day (Views: 9824, Comments: 1)
• Little used SSIS tasks: Data Profiling Task (Views: 7745, Comments: 3)
• Bring SQL Server databases Online or Offline when running on Amazon RDS (Views: 5620, Comments: 4)
• Turning on Optimize for Ad hoc Workloads, Ad Hoc Distributed Queries and more on a AWS RDS SQL Server Instance (Views: 4843, Comments: 0)
• How to read the error log on an Amazon RDS SQL Server instance (Views: 3988, Comments: 0)
• Trying out Amazon Relational Database Service (Views: 3940, Comments: 0)
• Creating a SQL Server Unique Index that behaves like an Oracle Unique Index (Views: 2299, Comments: 2)
• MongoDB 2.4 Released (Views: 1806, Comments: 0)
• Unique index difference between Oracle and SQL Server (Views: 2152, Comments: 1)
• Using WITH RESULT SETS with stored procedures that return multiple resultsets (Views: 1323, Comments: 1)
• Use WITH RESULT SETS to change column names and datatypes of a resultset (Views: 1888, Comments: 4)
• Goodbye Google Reader, hello feedly (Views: 2991, Comments: 7)
• Wrap inserts in a transaction for faster performance (Views: 5251, Comments: 1)
• SQL Server 2012 Business Intelligence Whitepaper and Data Tools released (Views: 3577, Comments: 0)
• Use the sp_describe_undeclared_parameters stored procedure to check if dynamic SQL has undeclared parameters (Views: 2817, Comments: 2)
• Giving only insert permissions to a table for a new login (Views: 2375, Comments: 0)
• Column name or number of supplied values does not match table definition when dealing with temp tables (Views: 2354, Comments: 8)
• Pesky resolutions, the two month checkup (Views: 870, Comments: 0)
• Double the trouble in less than half the time (Views: 766, Comments: 0)
• Windows Azure Training Kit available (Views: 1061, Comments: 0)
• An easier way to get SQL Server startup parameters: the sys.dm_server_registry dmv (Views: 1465, Comments: 1)
• MongoDB: Using the web-based administrative tool (Views: 1398, Comments: 0)
• Listing tables that are truly partitioned in SQL Server (Views: 1257, Comments: 1)
• Suppressing xp_cmdshell output (Views: 1072, Comments: 1)
• Ten things added after SQL Server 2000 that I like the most (Views: 2816, Comments: 2)
• MongoDB: Returning documents where fields are null or not existing (Views: 1846, Comments: 0)
• Listing all RESTORE and BACKUP operations currently going on your SQL Server (Views: 1113, Comments: 0)
• BULK INSERT data where the row terminator is a linefeed in SQL Server (Views: 1251, Comments: 1)
• Getting file size, space used and space free information for a SQL Server database (Views: 1176, Comments: 2)
• An Oracle NULL/Blank gotcha when coming from SQL Server (Views: 914, Comments: 0)
• Discovering new things (for me) in SSMS (Views: 1128, Comments: 4)
• SQL Server Support Windows Phone App released (Views: 1000, Comments: 2)
• Getting the tables with the most rows from your database (Views: 572, Comments: 0)
• Listing all your SQL Server databases ordered by size (Views: 679, Comments: 0)
• Getting the biggest tables in your SQL Server database (Views: 1131, Comments: 6)
• MongoDB: Creating capped collections (Views: 1028, Comments: 0)
• MongoDB: How to drop databases and collections (Views: 994, Comments: 0)
• A couple of ways to convert an integer to an coordinate with SQL Server (Views: 1145, Comments: 0)
• MongoDB: Exporting data into files (Views: 2012, Comments: 0)
• MongoDB: How to backup all the databases with one command (Views: 1645, Comments: 1)
• Umm....No...that is not how you export a table into a file with SQL Server (Views: 2227, Comments: 4)
• MongoDB: How to restore collections (Views: 1377, Comments: 0)
• MongoDB: How to backup and restore databases (Views: 2930, Comments: 1)
• MongoDB: How to limit results and how to page through results (Views: 4506, Comments: 0)
• How do you manage SQL Agent Jobs when using mirroring? (Views: 1764, Comments: 1)
• MongoDB: How to include and exclude the fields you want in results (Views: 2729, Comments: 0)
• Multidocument updates with MongoDB (Views: 1447, Comments: 0)
• Indexes in MongoDB: A quick overview (Views: 4483, Comments: 1)
• Displaying missing dates by utilizing a calendar table (Views: 2104, Comments: 1)
• Does anyone use the NTILE() windowing function? (Views: 1642, Comments: 4)
• MongoDB, how to sort results (Views: 4725, Comments: 1)
• What is going on with Database Mail in SQL Server (Views: 1827, Comments: 0)
• Database Mail maintenance in SQL Server (Views: 1201, Comments: 3)
• Setting up SQL Server Database Mail with gmail (Views: 4985, Comments: 4)
• Doing UPSERTs in MongoDB (Views: 2521, Comments: 0)
• Scala: The difference between val and var (Views: 1487, Comments: 0)
• Review of The Well-Grounded Java Developer (Views: 3030, Comments: 3)
• Giving users the ability to change a stored procedure without making them db_owner (Views: 2887, Comments: 2)
• Use the sys.database_mirroring DMV to quickly check if the databases are in principal or mirror role and what state they are in (Views: 1725, Comments: 0)
• Truncate rollback differences between SQL Server and Oracle (Views: 1919, Comments: 0)
• What is the Dual table in Oracle and why do I need it? (Views: 1590, Comments: 1)
• Differences between Oracle and SQL Server when working with NULL and blank values (Views: 2773, Comments: 1)
• Creating MongoDB as a service on Windows 8 (Views: 2517, Comments: 3)
• Installing Scala 2.10 on Eclipse Juno (Views: 2617, Comments: 1)
• Ah yes, those pesky resolutions (Views: 1071, Comments: 0)
• 2012 Analytics about Devices, Operating Systems and Browsers (Views: 1109, Comments: 0)
• 2012 Analytics about Searches, Countries and Content....... (Views: 1662, Comments: 0)
• SQL Advent 2012: Recap (Views: 2877, Comments: 0)
• SQL Advent 2012 Day 24: Getting help (Views: 2766, Comments: 0)
• SQL Advent 2012 Day 23: Get the tools you need to be more productive (Views: 3215, Comments: 1)
• D (Views: 782, Comments: 5)
• SQL Advent 2012 Day 22: Testing your backup and failover strategy (Views: 2814, Comments: 0)
• SQL Advent 2012 Day 21: With VLDBs it matters what you do and how you do it (Views: 3178, Comments: 0)
• SQL Advent 2012 Day 20: Use the new features (Views: 1746, Comments: 0)
• SQL Advent 2012 Day 19: How to improve your tech skills (Views: 3765, Comments: 3)
• SQL Advent 2012 Day 18: Stay relevant and marketable (Views: 3351, Comments: 3)
• SQL Advent 2012 Day 17: No matter how long you are on the wrong path, go back (Views: 3392, Comments: 0)
• SQL Advent 2012 Day 16: Lack of database design and normalization (Views: 3406, Comments: 0)
• SQL Advent 2012 Day 15: Benefits of Indexes (Views: 2982, Comments: 0)
• SQL Advent 2012 Day 14: When to say no (Views: 2708, Comments: 0)
• SQL Advent 2012 Day 13: Features enabled that are not used (Views: 2673, Comments: 0)
• SQL Advent 2012 Day 12: Proactive notifications (Views: 3460, Comments: 0)
• SQL Advent 2012 Day 11: Cursors and loops (Views: 2346, Comments: 2)
• SQL Advent 2012 Day 10: SQL Server Maintenance (Views: 2710, Comments: 0)
• SQL Advent 2012 Day 9: Reinventing the wheel (Views: 2738, Comments: 1)
• SQL Server Data Type Conversion Poster is available for download (Views: 2618, Comments: 1)
• SQL Advent 2012 Day 8: Foreign Keys (Views: 1803, Comments: 1)
• SQL Advent 2012 Day 7: Lack of constraints (Views: 2404, Comments: 3)
• SQL Advent 2012 Day 6: Standardized Naming And Other Conventions (Views: 2680, Comments: 2)
• SQL Advent 2012 Day 5: Do not trust the SSMS designers (Views: 2865, Comments: 7)
• Dealing with the Column name 'TEXT()' contains an invalid XML identifier as required by FOR XML; '('(0x0028) is the first character at fault error (Views: 2191, Comments: 0)
• SQL Advent 2012 Day 4: Triggers, what to do, what not to do (Views: 2888, Comments: 2)
• SQL Advent 2012 Day 3: Sargable Queries (Views: 3740, Comments: 2)
• SQL Advent 2012 Day 2: Data types storage differences (Views: 1868, Comments: 0)
• SQL Advent 2012 Day 1: Sizing database files (Views: 3134, Comments: 2)
• Java Training Day 5 (Views: 1948, Comments: 0)
• Java Training Day 4 (Views: 1383, Comments: 0)
• Java Training Day 3 (Views: 2009, Comments: 0)
• Java Training Day 2 (Views: 1073, Comments: 0)
• Java Training Day 1 (Views: 1341, Comments: 0)
• SQL Advent 2012, here is what is coming (Views: 2988, Comments: 4)
• Back to Java after an eleven year hiatus, what are some good resources you recommend? (Views: 895, Comments: 0)
• Find all the tables and indexes that have data compression (Views: 3611, Comments: 2)
• SQL Server 2012 SP1 and in-memory OLTP DB Engine Hekaton announced (Views: 3415, Comments: 0)
• Why do you need additional privileges for truncate table compared to delete? (Views: 3552, Comments: 0)
• Are you a real programmer, do you know all these artifacts you should know according to Uncle Bob? (Views: 4231, Comments: 12)
• How to name groups of tiles in Windows 8 (Views: 2368, Comments: 2)
• How to shutdown windows 8 (Views: 3403, Comments: 3)
• Windows 8, Visual Studio 2012 and Windows Server 2012 released to manufacturing (Views: 1585, Comments: 0)
• SQL Server 2008 R2 SP2 Released (Views: 5153, Comments: 0)
• E-Books in epu, mobi and pdf for Microsoft Technologies available for download (Views: 1928, Comments: 0)
• OUTPUT Clause and @@identity, scope_identity() (Views: 3344, Comments: 0)
• Backup to the cloud by using duplicati (Views: 6776, Comments: 0)
• How to change the SA password in SQL Server (Views: 4721, Comments: 3)
• Don't put a return statement in a stored procedure inside a transaction (Views: 2680, Comments: 3)
• SQL Azure How To Rebuild A Clustered Index (Views: 2855, Comments: 0)
• A couple of things to be aware of when working with tables in SQL Azure (Views: 3635, Comments: 6)
• How to search for data with underscores or brackets in SQL Server? (Views: 3058, Comments: 1)
• Review: Worm: The First Digital World War by Mark Bowden (Views: 2502, Comments: 0)
• Would you be interested in an information section for SQLCop? (Views: 2733, Comments: 4)
• Please don't use blacklists, use parameterized queries or stored procs instead (Views: 3338, Comments: 0)
• Downloading SQL Server Sample Databases much improved with new CodePlex changes (Views: 2307, Comments: 2)
• Dammit people, get to know check constraints and use them! (Views: 3653, Comments: 3)
• You don't need to shrink a database to get a smaller backup (Views: 1968, Comments: 0)
• Is your Apache Server Status wide open for the world to see? (Views: 3461, Comments: 1)
• How to give permissions to User-Defined Table Types (Views: 2578, Comments: 0)
• New 100MB database option and lower pricing across the board for SQL Azure (Views: 1132, Comments: 0)
• Getting the list of parameters from a stored procedure by using sqlCmd.Parameters or INFORMATION_SCHEMA.parameters (Views: 1794, Comments: 1)
• Difference between a cross join and a full outer join (Views: 5281, Comments: 3)
• Firefox heading for 15% market share? (Views: 7368, Comments: 13)
• How I use PowerShell to generate table output for blog posts from query results (Views: 1323, Comments: 2)
• How to connect to SQL Server when your default database is unavailable (Views: 2456, Comments: 2)
• Four Windows Phone Starter Kits Available (Views: 703, Comments: 0)
• Friday SQL Nugget #1 post (Views: 680, Comments: 0)
• Meme Monday: what is the first blogpost you wrote and when did you write it? (Views: 1473, Comments: 6)
• The Thank You Economy by Gary Vaynerchuk (Views: 1664, Comments: 0)
• SQL Azure Compatibility Assessment service released (Views: 2327, Comments: 2)
• Scripting data in SQL Server 2012 (Views: 1067, Comments: 6)
• Make 2012 the year that you will learn how to code (Views: 929, Comments: 5)
• 2011 A look back with some stats (Views: 1810, Comments: 0)
• SQL Advent 2011: What is coming in SQL Server 2012? (Views: 1103, Comments: 0)
• SQL Advent 2011 Recap (Views: 1162, Comments: 0)
• SQL Advent 2011 Day 24: Index REBUILD and REORGANIZE (Views: 1806, Comments: 0)
• Upgrade Assistant for SQL Server 2012 available for download (Views: 759, Comments: 0)
• SQL Advent 2011 Day 23: OBJECT_DEFINITION (Views: 1447, Comments: 0)
• SQL Advent 2011 Day 22: Dynamic Management Views (Views: 1507, Comments: 1)
• SQL Advent 2011 Day 21: TRY CATCH (Views: 1529, Comments: 0)
• SQL Advent 2011 Day 20: Indexes with Included Columns (Views: 1549, Comments: 1)
• SQL Advent 2011 Day 19: Filtered Indexes (Views: 1524, Comments: 2)
• SQL Advent 2011 Day 18: Table-valued Parameters (Views: 1559, Comments: 0)
• SQL Advent 2011 Day 17: varchar(max) (Views: 1660, Comments: 0)
• SQL Advent 2011 Day 16: CROSS APPLY and OUTER APPLY (Views: 1685, Comments: 0)
• SQL Advent 2011 Day 15: Joins (Views: 1506, Comments: 1)
• SQL Advent 2011 Day 14: EXCEPT and INTERSECT SET Operations (Views: 1736, Comments: 4)
• SQL Advent 2011 Day 13: DDL Triggers (Views: 1456, Comments: 0)
• SQL Advent 2011 Day 12: Table Value Constructor (Views: 1742, Comments: 2)
• SQL Advent 2011 Day 11: DML statements with the OUTPUT clause (Views: 1434, Comments: 1)
• SQL Advent 2011 Day 10: Upsert by using the Merge statement (Views: 2483, Comments: 0)
• Silverlight 5 available for download, will it be the last version? (Views: 1024, Comments: 0)
• SQL Advent 2011 Day 9: Dynamic TOP (Views: 1912, Comments: 4)
• SQL Advent 2011 Day 8: UNPIVOT (Views: 1222, Comments: 1)
• SQL Advent 2011 Day 7: Crosstab with PIVOT (Views: 2203, Comments: 0)
• SQL Advent 2011 Day 6: Windowing functions (Views: 2022, Comments: 3)
• SQL Advent 2011 Day 5: Common Table Expressions (Views: 2558, Comments: 2)
• SQL Advent 2011 Day 4: Schemas (Views: 1991, Comments: 1)
• SQL Advent 2011 Day 3: Partitioning (Views: 3789, Comments: 0)
• How to call a user defined function with a default parameter (Views: 1058, Comments: 0)
• SQL Advent 2011 Day 2: system tables and catalog views (Views: 2437, Comments: 0)
• How to capture the error output from a stored procedure when calling another stored procedure in SQL Server? (Views: 748, Comments: 0)
• SQL Advent 2011 Day 1: Date and time (Views: 4152, Comments: 4)
• Anecdotes about SQL AKA post 400 (Views: 1540, Comments: 1)
• Are you ready for SQL Server 2012 or are you still partying like it is 1999? (Views: 3467, Comments: 7)
• Showing sysjobhistory run_duration in HHMMSS format (Views: 1158, Comments: 0)
• Location of files for new database in SQL Server (Views: 735, Comments: 0)
• SQL Server 2012 RC0 available for download (Views: 453, Comments: 0)
• List all stored procedures that run at startup in SQL Server (Views: 810, Comments: 2)
• A trip down technology memory lane (Views: 2067, Comments: 1)
• What does a SQL Server DBA need to check for daily, weekly, monthly, quarterly and yearly? (Views: 1877, Comments: 0)
• Ghost in the wires by Kevin Mitnick a review (Views: 734, Comments: 0)
• SQL Server 2012 to be released Q1 2012 (Views: 1679, Comments: 0)
• Ada Lovelace Day..Do you remember which women have influenced you over the years? (Views: 833, Comments: 0)
• SQL Server 2008 Service Pack 3 has been released (Views: 1610, Comments: 3)
• Returning a value inserted in a table with a newsequentialid() default on a uniqueidentifier column (Views: 1305, Comments: 1)
• Review of In The Plex: How Google Thinks, Works, and Shapes Our Lives by Stephen Levy (Views: 544, Comments: 0)
• Don't fall for the social engineering scam that makes you go to ammyy.com (Views: 3390, Comments: 2)
• You need to have hardware virtualization enabled if you want to run Windows 8 in Virtual Box (Views: 27503, Comments: 14)
• Windows 8 Developer Preview with tools available for download (Views: 4707, Comments: 1)
• Google realizes that JavaScript is a dead end programming language, to be replaced by Dart a new language (Views: 3378, Comments: 1)
• Use common table expressions to simplify your updates in SQL Server (Views: 2721, Comments: 0)
• How much longer will the SQL Server database restore take (Views: 3136, Comments: 11)
• Microsoft SQL Server, codename "Denali", will be the last release to support OLE DB, ODBC is the new new thing (Views: 2113, Comments: 5)
• SQL Server Code Name “Denali” CTP3 Product Guide available for download (Views: 1406, Comments: 0)
• Review of Zero Day by Mark Russinovich (Views: 1984, Comments: 0)
• SQL Injection Pocket Reference for MySQL, SQL Server and Oracle (Views: 1806, Comments: 2)
• How to find what column caused the String or binary data would be truncated message (Views: 5161, Comments: 7)
• TRY_CONVERT in SQL Server Denali CTP3 (Views: 1290, Comments: 0)
• SQL Server Columnstore Index FAQ wiki page published (Views: 920, Comments: 0)
• Format function in SQL Server Denali CTP3 (Views: 1682, Comments: 0)
• Concat function in SQL Server Denali CTP3 (Views: 2209, Comments: 8)
• ColumnStore Index limitations in SQL Server Denali CTP3 (Views: 2227, Comments: 2)
• DATEFROMPARTS and DATETIMEFROMPARTS functions in SQL Server Denali CTP3 (Views: 2681, Comments: 5)
• A Quick look at the new EOMONTH function in SQL Server Denali CTP3 (Views: 2224, Comments: 5)
• A Quick look at the new IIF function in Denali CTP3 (Views: 2298, Comments: 7)
• SQL Server Code Name "Denali" CTP3 is available for download (Views: 721, Comments: 0)
• I hold this blog hostage for 1 million views mahaaahaha mahahaha.... (Views: 474, Comments: 5)
• What I have read so far this year (Views: 2030, Comments: 2)
• LulzSec has shut down, has ended hacking campaign (Views: 1797, Comments: 2)
• Compressing files with NTFS compression by running compact from the command line (Views: 2665, Comments: 0)
• HTML5 Support for the Visual Studio 2010 Editor available for download (Views: 1879, Comments: 1)
• Do you care that SQL Server Denali cannot be installed on Windows XP? (Views: 1427, Comments: 10)
• Review: Physics of the Future: How Science Will Shape Human Destiny and Our Daily Lives by the Year 2100 by Michio Kaku (Views: 1138, Comments: 0)
• A week in Sybase Training, what did I learn, day 5 (Views: 762, Comments: 0)
• A week in Sybase Training, what did I learn, day 4 (Views: 888, Comments: 0)
• A week in Sybase Training, what did I learn, day 3 (Views: 829, Comments: 0)
• A week in Sybase Training, what did I learn, day 2 (Views: 783, Comments: 0)
• A week in Sybase Training, what did I learn, day 1 (Views: 802, Comments: 0)
• Book review: Quantum Man: Richard Feynman's Life in Science (Views: 834, Comments: 0)
• Do you still use sp_change_users_login instead of ALTER USER UserName WITH LOGIN = UserName (Views: 3429, Comments: 2)
• Bing, Google and Yahoo! announce Schema.org (Views: 3403, Comments: 12)
• First look at the windows 8 UI (Views: 2398, Comments: 3)
• Less Than Dot is three years old, here are some stats (Views: 659, Comments: 2)
• Data Quality and Master Data Management with Microsoft SQL Server 2008 R2 book available as a free download (Views: 1262, Comments: 0)
• Book Review: Securing SQL Server By Denny Cherry (Views: 1004, Comments: 0)
• Watch all the Tech·Ed North America 2011 SQL Server videos (Views: 3238, Comments: 5)
• Raise your hand if you have seen code that sends email from within a trigger in SQL Server (Views: 2369, Comments: 9)
• Match your defaults with your trigger values to prevent horrible fragmentation on your indexes and tables (Views: 709, Comments: 1)
• SQL Server 2008 R2 SP1 CTP Available for download (Views: 1745, Comments: 0)
• Use DDL Triggers To Track Table Changes (Views: 2787, Comments: 2)
• Silverlight 5 Beta Is Available For Download (Views: 1046, Comments: 0)
• First Look at IE 10 (Views: 4427, Comments: 3)
• When changing column data types use ALTER TABLE TableName ALTER Column syntax, don't drop and recreate column (Views: 6082, Comments: 6)
• Be careful when passing around parameters, make sure they are the same size and type (Views: 2062, Comments: 1)
• What does the lock icon mean in SSMS when looking at a stored procedure? (Views: 2985, Comments: 2)
• Use a database how it was intended to be used (Views: 1337, Comments: 11)
• Use the GROUPING function to determine whether a value is NULL because of ROLLUP (Views: 2317, Comments: 1)
• Do you have Chimney Offload State disabled? (Views: 1555, Comments: 3)
• Visual Studio 2010 Service Pack 1 released on MSDN (Views: 715, Comments: 0)
• T-SQL Tuesday #016 Grouping Market Data With T-SQL (Views: 1254, Comments: 4)
• Learn the platform differences to be more effective (Views: 891, Comments: 0)
• New Collection of SQL Server Videos on Channel 9 (Views: 2600, Comments: 0)
• What does a SQL Server developer need to know? (Views: 5292, Comments: 29)
• Latest article by SQL Server MVP Erland Sommarskog is a gem (Views: 1404, Comments: 0)
• Windows 7 SP1 RTM available for MSDN and TechNet customers (Views: 2978, Comments: 0)
• Trapping errors when working with linked servers (Views: 3660, Comments: 0)
• Using Database Snapshot As A Protection Against Rogue Deletes (Views: 1661, Comments: 0)
• 2010 stats: most popular posts, search keywords and countries (Views: 891, Comments: 1)
• Review of my 2010 goals (Views: 1295, Comments: 2)
• 2010.. a year in stats..browsers, smartphones and windows flavors (Views: 1266, Comments: 10)
• How to move datafiles to a new drive in SQL Server (Views: 3822, Comments: 9)
• Dealing with The row value(s) updated or deleted either do not make the row unique or they alter multiple rows errors (Views: 4421, Comments: 1)
• SQL Server Denali CTP1 Announced at PASS (Views: 1890, Comments: 1)
• The new Dynamic Management Views in SQL Server Denali (Views: 1465, Comments: 0)
• Playing around with sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_object (Views: 1272, Comments: 0)
• Don't install Denali BIDS side by side with a 2008 instance (Views: 3749, Comments: 2)
• Find what is deprecated in SQL Server Denali by using sys.dm_os_performance_counters (Views: 2711, Comments: 1)
• Using OFFSET N ROWS FETCH NEXT N ROWS ONLY In SQL Server Denali for easy paging (Views: 6746, Comments: 4)
• Debugging In SQL Server Denali (Views: 1199, Comments: 0)
• Screenshots of the new look and feel of BIDS in Denali (Views: 2636, Comments: 0)
• A first look at sequences in SQL Server Denali (Views: 4314, Comments: 0)
• First look at SQL Server Management Studio Denali (Views: 10712, Comments: 4)
• What SQL Server book would you recommend for a Sybase and Oracle admin? (Views: 1061, Comments: 0)
• Use an OUTER LOOP JOIN for faster performance when one of the tables is much smaller (Views: 4014, Comments: 13)
• Tokenizing filenames in SQL Server (Views: 1772, Comments: 3)
• How to flip a bit in SQL Server by using the Bitwise NOT operator (Views: 3701, Comments: 5)
• SQL Server 2008 Service Pack 2 Released (Views: 3227, Comments: 1)
• Patch for the ASP.NET Padding Oracle vulnerability has been released (Views: 2035, Comments: 0)
• How to capture the error output from xp_cmdshell in SQL Server (Views: 6977, Comments: 1)
• When should you store @@ROWCOUNT into a variable? (Views: 4111, Comments: 0)
• Dealing with The multi-part identifier "dbo.Table.Column" could not be bound. error in an update statement (Views: 3452, Comments: 5)
• Searching for ranges when you have quarters and years (Views: 2463, Comments: 2)
• Post 300 or why all developers should be blogging (Views: 4791, Comments: 12)
• Misconceptions about unicode in SQL Server (Views: 1642, Comments: 2)
• How to return only weekend data for the last 4 weeks in SQL Server (Views: 1531, Comments: 4)
• SQLCop A Tool To Highlight Potential Problems With Your Database (Views: 8618, Comments: 16)
• MSDN giveaway winners (Views: 1247, Comments: 7)
• Final vote for the MSDN giveaway (Views: 904, Comments: 0)
• Vote for the MSDN giveaway winner (Views: 942, Comments: 6)
• MSDN Ultimate Subscription giveaway (Views: 8158, Comments: 31)
• Visual Studio 2010 and .NET Framework 4 Training Kit June 2010 Release Available (Views: 1304, Comments: 0)
• Checking for NULL values in all columns that allow NULLS in all the tables (Views: 3162, Comments: 2)
• How to clean a table from badly named column names (Views: 1313, Comments: 4)
• How to refresh the local IntelliSense cache in SQL Server Management Studio (Views: 3053, Comments: 5)
• Error: The GetBytes function can only be used on columns of type Text, NText, or Image (Views: 5401, Comments: 0)
• Less Than Dot is two years old, here are some stats (Views: 940, Comments: 0)
• Has FireFox lost its Mojo, are FireFox user jumping ship to Chrome? (Views: 2753, Comments: 12)
• Three different ways of populating variables with configuration values in SQL Server (Views: 2418, Comments: 4)
• How to use T-SQL to get the command line startup parameters that were used to start SQL Server (Views: 2441, Comments: 0)
• How to get the processid that SQL Server is using if you have multiple instances of SQL Server running (Views: 6091, Comments: 1)
• SQL Meme: Tagged: 5 things SQL Server should drop (Views: 2245, Comments: 4)
• SSIS A difference between C# and VB in a script task (Views: 5567, Comments: 3)
• How to insert values into a table with only an identity column (Views: 1860, Comments: 3)
• Debugging 64 bit SSIS packages (Views: 2479, Comments: 0)
• SQL Saturday New York City recap (Views: 1989, Comments: 2)
• Do you use disable index or drop index when running your ETL processes in SQL Server (Views: 4551, Comments: 0)
• Do you use Column=@Param OR @Param IS NULL in your WHERE clause? Don't, it doesn't perform (Views: 45861, Comments: 24)
• Visual Studio 2010 and Microsoft .NET Framework 4 Available for download today (Views: 1325, Comments: 8)
• MongoDB vs. SQL Server - INSERT comparison part deux (Views: 9615, Comments: 15)
• Getting the physical device name and backup time for a SQL Server database (Views: 3289, Comments: 4)
• Interview with me about the chapters I wrote for the SQL Server Deep Dives book (Views: 1010, Comments: 0)
• Formatting the time from a datetime or time datatype by using the STUFF function (Views: 3071, Comments: 5)
• A quick look at Windows Phone 7 development (Views: 4918, Comments: 6)
• Internet Explorer 9 available for a test drive (Views: 2774, Comments: 0)
• Visual Studio 2010 Concurrency Profiling And Parallel Programming (Views: 8418, Comments: 3)
• ASP.NET MVC 2 RTM for Visual Studio 2008 SP1 Released (Views: 2003, Comments: 0)
• Do You Get A Benefit From Compressing Backups If You Already Have Compressed Data? (Views: 1860, Comments: 6)
• Running sp_helpdb against a snapshot shows wrong files on SQL Server 2008 (Views: 1442, Comments: 0)
• If you are suffering from Cisco VPN on 64 bit Windows then use the Shrew Soft VPN client (Views: 5241, Comments: 6)
• Visual Studio 2010 and .NET 4 release candidates available for download (Views: 824, Comments: 0)
• Use Filters in SSMS to only see the things that are of interest to you (Views: 1848, Comments: 2)
• Interesting UNION with ORDER BY behavior (Views: 1535, Comments: 2)
• ASP.NET MVC 2 (Release Candidate 2) Released (Views: 2899, Comments: 0)
• Windows Azure Tools for Microsoft Visual Studio 1.1 Released (Views: 1774, Comments: 0)
• Running static code analysis on SQL Server database with Visual Studio Team System for database architects (Views: 1633, Comments: 0)
• Use sys.dm_os_performance_counters to get your Buffer cache hit ratio and Page life expectancy counters (Views: 10336, Comments: 7)
• Use alter table alter column to change datatypes for a column in SQL Server (Views: 13171, Comments: 0)
• SQL Server 2008 R2 to be released in May (Views: 1030, Comments: 0)
• How to return all the skipped identity values from a table in SQL Server (Views: 1806, Comments: 2)
• Setting up SQL Server with ASP.NET MVC (Views: 11302, Comments: 4)
• Find Out If You Are Using Deprecated Features In SQL Server 2008 (Views: 4336, Comments: 5)
• Interview with Brent Ozar about the book Professional SQL Server 2008 Internals and Troubleshooting (Views: 2028, Comments: 2)
• Find Out What Percent Of The Log Is Being Used For Each Database In SQL Server 2005 and 2008 (Views: 2678, Comments: 2)
• Microsoft Announces SQL Server Migration Assistant for MySQL (Views: 1906, Comments: 0)
• 2010 Goals For SQLDenis (Views: 905, Comments: 2)
• Daemon by Daniel Suarez is a book every programmer will love (Views: 5031, Comments: 1)
• SQL Azure CTP Testers Can Upgrade Their Accounts To Paid Commercial Subscriptions Starting Today (Views: 1592, Comments: 0)
• How To Enable GodMode On Windows 7 (Views: 44930, Comments: 22)
• The most read posts and most searched keywords for 2009 on LessThanDot in 2009 (Views: 1543, Comments: 3)
• How To Modify The Host File In Windows 7 Or Vista (Views: 6599, Comments: 4)
• My top ten favorite technologies of this decade. (Views: 2313, Comments: 13)
• Visual Studio 2010 Beta 2 Virtual Machines with Sample Data Available (Views: 1532, Comments: 0)
• Testing backup compression in SQL Server 2008 (Views: 3905, Comments: 7)
• Best Practice: Coding SQL Server triggers for multi-row operations (Views: 11505, Comments: 9)
• SQL Server 2008 R2 November CTP Available For Download (Views: 1139, Comments: 0)
• SQL Server 2008 R2 Editions Pricing Announced (Views: 3810, Comments: 3)
• SQL Server 2008 R2 Datacenter and SQL Server 2008 R2 Parallel Data Warehouse Editions Announced (Views: 2051, Comments: 3)
• If you want to learn about Google Wave then check out the book The Complete Guide to Google Wave (Views: 1338, Comments: 6)
• Oracle Details Its Plans For MySQL, Java, Virtualization, NetBeans, Glassfish, OpenOffice And Open Source (Views: 8215, Comments: 3)
• Interesting Increase Key Value Post By CSS SQL Server Engineers (Views: 3614, Comments: 8)
• Dealing with Cannot resolve collation conflict for equal to operation errors (Views: 7485, Comments: 4)
• Windows 7 Launch In New York City (Views: 3121, Comments: 4)
• Visual Studio 2010 and .NET Framework 4 Beta 2 Available on MSDN (Views: 2050, Comments: 1)
• Win A Copy Of SQL Server 2008 Administration in Action (Views: 2202, Comments: 0)
• Interview With Rod Colledge About The Book SQL Server 2008 Administration in Action (Views: 5620, Comments: 7)
• T-SQL To find Out If An Index Is Clustered Or Non Clustered (Views: 3559, Comments: 3)
• Do we need to know basic math as programmers? (Views: 43356, Comments: 48)
• Calculating The Percentage Of Null Values In A Column With Transact SQL (Views: 6252, Comments: 2)
• Five Google Wave Invitations are up for grabs (Views: 5557, Comments: 49)
• Microsoft Security Essentials, available for download tomorrow (Views: 2336, Comments: 0)
• Review of SQL Server 2008 Administration in Action (Views: 3529, Comments: 0)
• SQL Server MVP Deep Dives a book written by SQL Server MVPs supporting a good cause (Views: 4539, Comments: 7)
• Use INDEXKEY_PROPERTY in SQL Server to determine if columns in indexes are sorted ascending or descending (Views: 2828, Comments: 2)
• How I got started with SQL Server (Views: 2570, Comments: 0)
• Learn About SQL Server 2008 R2 Project Gemini And Project Madison By Watching These Videos (Views: 3009, Comments: 0)
• SSMS Tools PACK, Something Every SQL Server Developer That Uses SSMS Should Have Installed (Views: 10716, Comments: 13)
• Scripting all jobs on SQL Server 2005/2008 into one file (Views: 8421, Comments: 5)
• SQL Server StreamInsight CTP2 Available For Download (Views: 2969, Comments: 0)
• Scripting All The Jobs On Your SQL Server Instance Into Separate Files By Using SMO (Views: 6310, Comments: 7)
• SQL Server 2008 R2 August Community Technology Preview (CTP) Announced (Views: 6872, Comments: 0)
• SQL Server sprawl, heard it twice in one day (Views: 3217, Comments: 3)
• Finding Out How Many Times A Table Is Being Used In Ad Hoc Or Procedure Calls In SQL Server 2005 And 2008 (Views: 6158, Comments: 7)
• When Books On Line is not really correct (Views: 2585, Comments: 2)
• Highly Critical Adobe Reader/Acrobat SWF Content Arbitrary Code Execution Vulnerability (Views: 1799, Comments: 0)
• Windows 7 and Windows Server 2008 R2 Released To Manufacturing (Views: 2202, Comments: 1)
• Dealing with the could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT error message (Views: 5320, Comments: 0)
• The differences between LEN and DATALENGTH in SQL Server (Views: 8259, Comments: 4)
• Ecofont, Will this save the planet? (Views: 4918, Comments: 7)
• Operand type clash: date is incompatible with int error when trying to do +1 on a date data type in SQL Server 2008 (Views: 22289, Comments: 4)
• Windows Azure, SQL Azure and .NET Services pricing announced (Views: 4375, Comments: 1)
• Messing around with Office 2010, I like what I see (Views: 1733, Comments: 0)
• Vulnerability in Microsoft Office Web Components control could allow remote code execution (Views: 1417, Comments: 0)
• A couple of ways of getting the top 2 distinct values from a set in SQL Server (Views: 2661, Comments: 4)
• Vulnerability in Microsoft Video ActiveX control could allow remote code execution (Views: 2261, Comments: 0)
• How to copy data/append data into files from within T-SQL (Views: 10217, Comments: 0)
• How To Script Out The Whole Database In SQL Server 2005 and SQL Server 2008 (Views: 3645, Comments: 4)
• Adding time offsets passed in to a datetime to generate localized datetime (Views: 2530, Comments: 2)
• Can't depend on sp_depends? Try using sp_refreshsqlmodule (Views: 4404, Comments: 0)
• Replace Your Case When Then Else Syntax With the Sign Function In SQL Server (Views: 6513, Comments: 1)
• Use FOR XML AUTO,TYPE, ELEMENTS to get XML in the format you really want with SQL Server FOR XML Syntax (Views: 8246, Comments: 1)
• How to Install Internet Information Services (IIS) On Windows 7 (Views: 1627, Comments: 0)
• Having Fun With OPENQUERY And Update,Delete And Insert Statements (Views: 10290, Comments: 0)
• Dealing with A transport-level error has occurred when sending the request to the server errors (Views: 5452, Comments: 2)
• Listing All The User-Defined Data Types That Were Created On Your SQL Server (Views: 3410, Comments: 0)
• Review Of Beginning Spatial With SQL Server 2008 (Views: 2635, Comments: 0)
• Bing, worth switching from Google? (Views: 2268, Comments: 3)
• How to mount ISO images on Vista or Windows 7 (Views: 7060, Comments: 4)
• Optional and named arguments in C# a comparison with SQL Server stored procs (Views: 2084, Comments: 1)
• Avoid Conversions In Execution Plans By Using sp_executesql Instead of Exec (Views: 8881, Comments: 6)
• Changing exec to sp_executesql doesn't provide any benefit if you are not using parameters correctly (Views: 10562, Comments: 10)
• Enabling ReadyBoost In Vista (Views: 1691, Comments: 0)
• Your testbed has to have the same volume of data as on production in order to simulate normal usage (Views: 4168, Comments: 9)
• Less Than Dot A Year In Review (Views: 1336, Comments: 5)
• Grouping datetime values in half hour blocks in SQL Server (Views: 4068, Comments: 3)
• Vulnerability in DirectX Could Allow Remote Code Execution (Views: 1521, Comments: 0)
• Is an index seek always better or faster than an index scan? (Views: 4895, Comments: 1)
• SQL Server does support regular expressions in check constraints, triggers are not always needed (Views: 10495, Comments: 3)
• Here Is Yet Another Reason For Upgrading To SQL Server 2008 From SQL Server 2000 (Views: 986, Comments: 0)
• SQL Server 2008 Developer Training Kit Available For Download (Views: 1382, Comments: 0)
• Vulnerability in IIS Could Allow Elevation of Privilege (Views: 2385, Comments: 0)
• Visual Studio 2010 Screenshots (Views: 11209, Comments: 5)
• Microsoft bans memcpy() to minimize buffer overflows (Views: 4566, Comments: 0)
• SQLCop, FxCop For SQL Server, Would You Be Interested in This? (Views: 4859, Comments: 7)
• SQL Server 2008 R2 Announced, CTP Coming This Summer (Views: 1918, Comments: 0)
• Creating A XSD Schema From A Table In SQL Server With FOR XML Syntax (Views: 6904, Comments: 3)
• Banish IE6? Not As Easy As You Think (Views: 1321, Comments: 2)
• Some PostgreSQL Announcements (Views: 1109, Comments: 0)
• Microsoft Enterprise Developer Conference Overview (Views: 2265, Comments: 0)
• SQL Rap: I am the DBCC, yeah u know me (Views: 2817, Comments: 2)
• How to import a bunch of XML files from a directory in T-SQL (Views: 3514, Comments: 3)
• How To Disable Autogenerated Comments When You Script Out Objects (Views: 1835, Comments: 2)
• How to pad positive and negative number with zeroes in SQL Server? (Views: 4825, Comments: 4)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 18 (Views: 1983, Comments: 0)
• Troubleshooting Performance Problems in SQL Server 2008 White Paper Released (Views: 2107, Comments: 0)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 17 (Views: 1964, Comments: 0)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 16 (Views: 1633, Comments: 0)
• Answers To The SQL Server Quiz: Can You Answer All These Post (Views: 5357, Comments: 4)
• SQL Server Quiz, Can You Answer All These? (Views: 9197, Comments: 9)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 15 (Views: 1445, Comments: 0)
• MIX09, SilverLight 3, Expression Blend 3, IE8, ASP.NET MVC 1.0 And Much More (Views: 6652, Comments: 2)
• ASP.NET MVC 1.0 Has Been Released (Views: 1554, Comments: 2)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 14 (Views: 1839, Comments: 0)
• Patterns And Practices Application Architecture Guide 2.0, Something Everyone Should Read (Views: 3360, Comments: 0)
• Free ASP.NET MVC eBook Tutorial in pdf format (Views: 5601, Comments: 5)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 14 (Views: 1614, Comments: 0)
• Create XML Files Out Of SQL Server With SSIS And FOR XML Syntax (Views: 34118, Comments: 52)
• ASP.NET MVC Release Candidate 2 Has Been Released (Views: 2560, Comments: 0)
• Collection Of Puzzles For Programmers (Views: 78236, Comments: 6)
• FireFox, Chrome and Internet Explorer 8 Memory Usage, IE8 Uses More Memory Than Chrome and FireFox Combined (Views: 7219, Comments: 6)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 13 (Views: 1877, Comments: 0)
• Learn Visual Studio 2010 now by watching these videos (Views: 11106, Comments: 0)
• Podcasts I Listen To (Views: 2773, Comments: 1)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 12 (Views: 1381, Comments: 0)
• How To Name Default Constraints And How To Drop Default Constraint Without A Name In SQL Server (Views: 7903, Comments: 2)
• What was your first computer and what were some of your favorite games? (Views: 9312, Comments: 19)
• Debian GNU/Linux 5.0 Lenny released (Views: 1815, Comments: 1)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 11 (Views: 1719, Comments: 0)
• SQL Server 2008 Proximity Search With The Geography Data Type (Views: 34648, Comments: 43)
• Kaspersky Web Site Hacked With SQL Injection, How Embarrassing Is This? (Views: 4104, Comments: 2)
• Suppress string or binary data would be truncated messages with the ANSI WARNINGS setting (Views: 24024, Comments: 5)
• Review of Pro SQL Server 2008 Relational Database Design and Implementation (Views: 3757, Comments: 0)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 10 (Views: 1451, Comments: 0)
• An Interview With Kevin Kline About SQL In A Nutshell Third Edition (Views: 5157, Comments: 3)
• Key Feature list For All the Different Windows 7 Versions (Views: 2303, Comments: 1)
• Kaxaml a lightweight XAML editor (Views: 2274, Comments: 1)
• SQL Server 2008 Books Online Jan, 2009 download now available (Views: 1889, Comments: 0)
• How to enable xp_cmdshell and Ad Hoc Distributed Queries on SQL Server 2005 (Views: 31813, Comments: 11)
• Magnolia crashed data corruption and loss (Views: 1810, Comments: 0)
• Has Google Been Hacked? Every search result shows This site may harm your computer. (Views: 3331, Comments: 13)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 9 (Views: 1340, Comments: 0)
• ASP.NET MVC 1.0 Release Candidate Now Available For Download (Views: 1513, Comments: 0)
• Cool Way To Launch The Malicious Software Removal Tool (Views: 3096, Comments: 1)
• how to make sure that the view will have the underlying table changes by using sp_refreshview (Views: 3010, Comments: 4)
• VMware Powershell VI Toolkit 1.5 Released for Windows with 32 new cmdlets (Views: 2862, Comments: 0)
• Internet Explorer 8 Release Candidate 1 Available For Download (Views: 1564, Comments: 0)
• PerformancePoint Server To Become PerformancePoint Services In SharePoint Server (Views: 2561, Comments: 0)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 8 (Views: 1135, Comments: 0)
• X# a domain specific language designed to quickly create Web applications and services (Views: 1831, Comments: 5)
• Win32/Conficker.B also known as Downadup worm infections warning (Views: 5315, Comments: 6)
• Do you use Metasploit to check if your servers are vulnerable? (Views: 2404, Comments: 2)
• How to implement a typeof operator in SQL by using sql_variant_property (Views: 3597, Comments: 3)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 7 (Views: 1347, Comments: 0)
• Return all the columns in the database which allow NULLS (Views: 2810, Comments: 0)
• The Most Used Words On Our Blog (Views: 2129, Comments: 1)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 6 (Views: 1178, Comments: 0)
• The SQL Server Memory Leak Confusion (Views: 12437, Comments: 8)
• Site is no more after they discover they did not have SQL Server backups (Views: 2641, Comments: 5)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 5 (Views: 1372, Comments: 0)
• My to-do list for 2009 (Views: 3931, Comments: 3)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 4 (Views: 4313, Comments: 1)
• Want To Learn Scrum? Visit About Scrum. (Views: 3895, Comments: 0)
• sp_replwritetovarbin Heap Overflow Code Exploit Code In The Wild, Works By Using Our Good Friend SQL Injection (Views: 4879, Comments: 5)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 3 (Views: 3610, Comments: 0)
• SQL Server 2005 Service Pack 3 has been released (Views: 2342, Comments: 1)
• IronPython 2.0 has been released, now runs on top of the Dynamic Language Runtime (DLR) (Views: 1953, Comments: 0)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 2 (Views: 2472, Comments: 0)
• CHESS: An Automated Concurrency Testing Tool (Views: 3001, Comments: 0)
• The Ten Most Asked SQL Server Questions And Their Answers (Views: 66001, Comments: 49)
• Financial Functions for .NET released (Views: 3026, Comments: 0)
• SQL Friday, The Best SQL Server Links Of The Past Week Episode 1 (Views: 2255, Comments: 3)
• Failed to access IIS metabase or why it is important to do things in the correct order (Views: 3169, Comments: 0)
• sqltrace: A Tool Every SQL Server Developer Should Have (Views: 2049, Comments: 0)
• SQL Server Application and Multi-Server Management Private CTP (Views: 1451, Comments: 0)
• SQL Server 2008 Upgrade Technical Reference Guide Available For Download (Views: 3479, Comments: 1)
• Cumulative update package 2 for SQL Server 2008 is available (Views: 4723, Comments: 1)
• SQL Server Fabric and DATAllegro demo at PASS, SQL Data Services Public CTP Available (Views: 2440, Comments: 0)
• Cumulative Update 1 to the RML Utilities for Microsoft SQL Server Released (Views: 1570, Comments: 0)
• What is wrong with this code? (Views: 1591, Comments: 0)
• Visual Studio 2010 and the .NET Framework 4.0 Week, 12 videos on Channel 9 (Views: 2284, Comments: 0)
• Finding Fragmentation Of An Index And Fixing It (Views: 6748, Comments: 2)
• Windows Server 2008 R2 Will Support 256 Logical Processors (Views: 2256, Comments: 0)
• Free Microsoft Chart Controls for Microsoft .NET Framework 3.5 (Views: 5898, Comments: 0)
• Create a sorted view in SQL Server 2005 and SQL Server 2008 (Views: 12711, Comments: 5)
• Windows Azure From A Developer's Perspective Post (Views: 2441, Comments: 0)
• Windows Server 2008 R2 is the first Windows OS platform to go 64-bit only (Views: 2457, Comments: 0)
• SQL Server 2005 Service Pack 3 - Beta Available For Download (Views: 1971, Comments: 1)
• Microsoft SQL Server 2008 Feature Pack October 2008 Available For Download (Views: 2582, Comments: 0)
• .NET Framework 4 Poster In PDF and DeepZoom Formats (Views: 3864, Comments: 1)
• Can't go to PDC 2008, watch the videos on Channel 9 and on the PDC 2008 site (Views: 2101, Comments: 0)
• The new features in C# 4.0 (Views: 11079, Comments: 5)
• Azure Services Platform Is In CTP (Views: 1368, Comments: 0)
• Dependency Injection Tool StructureMap 2.5 Has Been Released (Views: 2417, Comments: 2)
• Flash Player 10 has been released (Views: 2128, Comments: 1)
• OpenOffice 3.0 is now available (Views: 1328, Comments: 0)
• Microsoft releases Silverlight 2 announces development capabilities with Eclipse (Views: 3509, Comments: 1)
• Will Silverlight 2 Be RTM Tomorrow? (Views: 932, Comments: 1)
• FILESTREAM Storage in SQL Server 2008 Technical Article (Views: 4221, Comments: 1)
• The Manga Guide to Databases (Views: 3650, Comments: 4)
• Google Interview Questions (Views: 19179, Comments: 20)
• SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support (Views: 2088, Comments: 3)
• Mono 2.0 Has Been Released (Views: 1286, Comments: 0)
• Kilimanjaro is the code name for the next version of SQL Server (Views: 1560, Comments: 0)
• Npgsql2 the PostgreSQL Net Data provider written 100% in C# has been released (Views: 3053, Comments: 0)
• How To Convert IP Addresses Between Bigint and Varchar (Views: 8730, Comments: 8)
• Free SQL Server Books (Views: 2260, Comments: 1)
• Poll: Which of the following SQL Server features do you use? (Views: 1284, Comments: 0)
• Run Microsoft Windows Server And SQL Server in the cloud on Amazon EC2 (Views: 2450, Comments: 5)
• Review of MCTS Self-Paced Training Kit (Exam 70-502): Microsoft .NET Framework 3.5 Windows Presentation Foundation (Views: 2508, Comments: 0)
• Microsoft Unveils Next Version of Visual Studio and .NET Framework: Visual Studio 2010 and the .NET Framework 4.0 (Views: 2831, Comments: 0)
• jQuery will ship with ASP.NET MVC and Visual Studio! (Views: 2147, Comments: 0)
• SQL Server 2008 Cumulative Update 1 is available from Microsoft (Views: 10345, Comments: 2)
• ISO Week In SQL Server (Views: 27015, Comments: 11)
• Interview With Louis Davidson Author of Pro SQL Server 2008 Relational Database Design and Implementation (Views: 5756, Comments: 10)
• Nice .NET Design Patterns Articles (Views: 2422, Comments: 0)
• Google Chrome Dev Channel: Early Access to Features and Fixes (Views: 1975, Comments: 4)
• DATAllegro acquisition to enable SQL Server to scale into hundreds of terabytes of data (Views: 2266, Comments: 1)
• 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 (Views: 1772, Comments: 0)
• One Second Caching, Brilliant Or Insane? (Views: 2724, Comments: 6)
• What is deferred name resolution and why do you need to care? (Views: 3828, Comments: 4)
• F# Developer Center (Views: 1199, Comments: 0)
• Get A Free SQL Server 2008 Ebook (Views: 2224, Comments: 2)
• Django 1.0 Released (Views: 1708, Comments: 0)
• Stats For The Last Three Months (Views: 1802, Comments: 2)
• WPF Performance Profiling Tools (Views: 2016, Comments: 0)
• Find Out The Recovery Model For Your Database (Views: 7135, Comments: 0)
• How to Rebuild System Databases in SQL Server 2008 (Views: 1601, Comments: 2)
• LINQ to SQL queries involving strings cause SQL Server procedure cache bloat (Views: 6715, Comments: 6)
• SQL Server 2008 Express with Advanced Services And SQL Server 2008 Express With Tools Now Available For Download (Views: 1964, Comments: 1)
• How Do You Check If A Temporary Table Exists In SQL Server (Views: 11741, Comments: 0)
• Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code (Views: 15980, Comments: 19)
• .NET Framework 3.5 SP1: LINQ perf improvements (LINQ to Objects and LINQ to SQL) (Views: 1620, Comments: 0)
• ISO-11179 Naming Conventions (Views: 10862, Comments: 0)
• Microsoft SQL Server 2008 Feature Pack, August 2008 Available for download (Views: 1802, Comments: 0)
• SQL Server 2008 cannot be installed if you have Visual Studio 2008 RTM installed (Views: 2059, Comments: 1)
• Getting The Percentage Of NULLS And Values In A SQL Server Table (Views: 2345, Comments: 0)
• How Are Dates Stored In SQL Server? (Views: 8919, Comments: 2)
• How Does Between Work With Dates In SQL Server? (Views: 7006, Comments: 1)
• Converting Columns To Date From Datetime Does Not Result In A Scan In SQL Server 2008 (Views: 2988, Comments: 3)
• 5 Books Every Developer Should Read (Views: 8304, Comments: 7)
• SQL Server 2008 geography data type screencasts on Channel 9 (Views: 3163, Comments: 1)
• Vulnerabilities in Microsoft SQL Server Could Allow Elevation of Privilege (Views: 1675, Comments: 0)
• sp_indexinfo an enhanced index information procedure (Views: 1343, Comments: 0)
• An Introduction to New T-SQL Programmability Features in SQL Server 2008 (Views: 1602, Comments: 0)
• Sybase IQ Is A Columnar Database, Why Should I Care? (Views: 11282, Comments: 6)
• Use The XSS (Cross Site Scripting) Cheat Sheet To Check Your Site For Cross Site Scripting Attacks (Views: 27649, Comments: 1)
• Microsoft Has Released Tools To Address SQL Injection Attacks (Views: 2871, Comments: 0)
• How To Restart A Remote Computer (Views: 4086, Comments: 2)
• Three Ways To Return All Rows That Contain Uppercase Characters Only (Views: 890, Comments: 0)
• How to rename a column in a SQL Server table without using the designer (Views: 1771, Comments: 3)
• 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 (Views: 1127, Comments: 0)
• Compound Operators Or How T-SQL Is Morphing Into VB Or C# (Views: 5169, Comments: 12)
• SQL Server 2008 Adds ISO Week,TZoffset, Nanosecond And Microsecond To Datepart (Views: 2851, Comments: 3)
• SQL Server 2008 Release Candidate 0 Available To The General Public (Views: 696, Comments: 0)
• Do you have any questions for Paul Nielsen or Louis Davidson (Views: 886, Comments: 2)
• SQL Server 2008 Release Candidate 0 Available For Download (Views: 1073, Comments: 0)
• OPENROWSET And Excel Problems (Views: 9243, Comments: 4)
• Podcast: SQL Server 2008 Security and Availability, Management, Troubleshooting and Throttling (Views: 1365, Comments: 1)
• SQL Server 2008 Logo (Views: 2616, Comments: 3)
• Microsoft Source Analysis for C# Announced (Views: 1130, Comments: 0)
• Good SQL Articles To Read If You Can't Afford Books (Views: 23560, Comments: 18)
• How to get the selectivity of an index (Views: 1765, Comments: 0)
• Review of Inside Microsoft SQL Server 2005 Query Tuning and Optimization (Views: 1798, Comments: 0)