Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Your profile
Tag cloud
.net android asp.net asp.net mvc azure backup bigdata book c# community continuous delivery database denali functions gotcha how to howto indexing java linq mongodb nancy nhibernate nosql performance powershell ruby security silverlight sql sql advent 2012 sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 sql server 2012 sql server denali ssis ssms ssrs structuremap t-sql tip training unit testing vb.net visual studio 2010 windows 7
Authors
- SQLDenis (577)
- Christiaan Baes (chrissie1) (527)
- Ted Krueger (onpnt) (332)
- Jes Schultz Borland (grrlgeek) (139)
- Eli Weinstock-Herman (tarwn) (116)
- Alex Ullrich (51)
- George Mastros (gmmastros) (46)
- Naomi Nosonovsky (27)
- Axel Achten (axel8s) (23)
- David Forck (thirster42) (22)
- Koen Verbeeck (20)
- Kevin Conan (18)
- chopstik (18)
- Rob Earl (14)
- thatrickguy (12)
- More...
Main Categories
Search
XML FeedsGoogle Ads
Tags: sql server denali
Microsoft SQL Server, codename "Denali", will be the last release to support OLE DB, ODBC is the new new thing
According to the Microsoft SQLNCli team blog, SQL Server, codename "Denali", will be the last release to support OLE DB. Here is what they are currently saying The next release of Microsoft SQL Server, codename “Denali”, will be the last release t…
Watch all the Tech·Ed North America 2011 SQL Server videos
If you missed Tech·Ed North America 2011, I have compiled a list of all the SQL Server videos for you. Each one links directly to the video, have fun watching it all Microsoft SQL Server Code-Named "Denali" AlwaysOn Series,Part 1: Introducing the…
Dealing with The row value(s) updated or deleted either do not make the row unique or they alter multiple rows errors
Someone asked about this error this morning and I decided to turn it into a blog post. Basically the person was using the designer/editor in SSMS to delete a row, the table didn't have a key and the rows were not unique, he got the following error: The…
SQL Server Denali CTP1 Announced at PASS
Today at PASS the SQL Server team has publicly announced the first Community Technology Preview of the next version of SQL Server code named Denali. You can download it here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92…
The new Dynamic Management Views in SQL Server Denali
With SQL Server Denali CTP1 come 20 new dynamic management views, this brings the total number of dynamic management views to 155 Here is a list of the new dynamic management views, included is also the type of the dynamic management view…
Playing around with sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_object
If you have a stored procedure which returns two result sets up till now there was now way to get the meta data easily about the first result set. Let's take a look what is new in SQL Server Denali, first create this very simple stored procedure. cre…
Don't install Denali BIDS side by side with a 2008 instance
If you already have a SQL Server 2008 or a SQL Server 2008 R2 instance then do not install SQL Server Denali as a named instance. If you do so then your current SSIS development environment will be broken. There is a reason there are virtual machines, I…
Find what is deprecated in SQL Server Denali by using sys.dm_os_performance_counters
With every version of SQL Server come warnings about features/code that is deprecated. You can use the sys.dm_os_performance_counters dynamic management view to find what these deprecated features are. If you run the following query on SQL Server De…
Using OFFSET N ROWS FETCH NEXT N ROWS ONLY In SQL Server Denali for easy paging
SQL Server Denali makes it much easier to do paging compared to previous versions of SQL Server. In SQL Server 2005 or 2008 you would do something like the following to skip the first 50 rows WITH cte AS (SELECT ROW_NUMBER() OVER(ORDER BY number) AS…
Debugging In SQL Server Denali
Debugging has been improved in SQL Server Denali, here is a quick video that shows you how you can set a break point hit count and then while debugging it will stop when it hits that value. Of course stuff like this has been around forever in Visual Studio, I am glad that it now is also available in SSMS
:: Next >>
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.