SQL Server Code,Tips and Tricks, Performance Tuning

A blog about SQL Server, Books, Movies and life in general

Google Interview Questions | Microsoft SQL Server Books | personal blog | Ken Henderson Interview | Louis Davidson Interview

Tuesday, November 09, 2010

Post I created about SQL Server Denali

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-9c92-f7e5677d91f9



I have been playing around with Denali for a couple of weeks now and created a couple of posts. Below is a list of the posts, click on each link to get some more information about Denali

First look at SQL Server Management Studio Denali

Screenshots of the new look and feel of BIDS in Denali

Find what is deprecated in SQL Server Denali by using sys.dm_os_performance_counters

Playing around with sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_object

A first look at sequences in SQL Server Denali

Don’t install Denali BIDS side by side with a 2008 instance

The new Dynamic Management Views in SQL Server Denali

Debugging In SQL Server Denali

Using OFFSET N ROWS FETCH NEXT N ROWS ONLY In SQL Server Denali for easy paging
Posted by Denis Gobo at 5:44 PM 1 comment:
Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest
Links to this post
Labels: Denali, SQL Server
Reactions: 
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Follow me on:

Twitter
Instagram
Flickr

About Me

My photo
Denis Gobo
View my complete profile

Blog Archive

  • ►  2019 (9)
    • ►  February (5)
    • ►  January (4)
  • ►  2018 (7)
    • ►  November (1)
    • ►  September (2)
    • ►  May (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2017 (35)
    • ►  December (1)
    • ►  November (1)
    • ►  October (11)
    • ►  August (3)
    • ►  July (3)
    • ►  June (3)
    • ►  May (4)
    • ►  April (2)
    • ►  February (2)
    • ►  January (5)
  • ►  2016 (56)
    • ►  December (7)
    • ►  November (24)
    • ►  October (8)
    • ►  September (1)
    • ►  May (3)
    • ►  March (7)
    • ►  February (3)
    • ►  January (3)
  • ►  2015 (25)
    • ►  October (9)
    • ►  September (16)
  • ►  2013 (1)
    • ►  September (1)
  • ►  2012 (4)
    • ►  December (2)
    • ►  January (2)
  • ►  2011 (2)
    • ►  December (1)
    • ►  July (1)
  • ▼  2010 (1)
    • ▼  November (1)
      • Post I created about SQL Server Denali
  • ►  2009 (3)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
  • ►  2008 (89)
    • ►  November (1)
    • ►  October (3)
    • ►  September (1)
    • ►  August (5)
    • ►  July (5)
    • ►  June (5)
    • ►  May (14)
    • ►  April (11)
    • ►  March (13)
    • ►  February (16)
    • ►  January (15)
  • ►  2007 (258)
    • ►  December (27)
    • ►  November (21)
    • ►  October (9)
    • ►  September (6)
    • ►  August (19)
    • ►  July (26)
    • ►  June (16)
    • ►  May (22)
    • ►  April (23)
    • ►  March (38)
    • ►  February (29)
    • ►  January (22)
  • ►  2006 (266)
    • ►  December (23)
    • ►  November (24)
    • ►  October (35)
    • ►  September (25)
    • ►  August (20)
    • ►  July (18)
    • ►  June (19)
    • ►  May (24)
    • ►  April (17)
    • ►  March (21)
    • ►  February (21)
    • ►  January (19)
  • ►  2005 (58)
    • ►  December (16)
    • ►  November (16)
    • ►  October (15)
    • ►  September (11)

Popular Posts

  • Five Ways To Return Values From Stored Procedures
    I have answered a bunch of questions over the last couple of days and some of them had to do with returning values from stored procedures Ev...
  • After 20+ years in IT .. I finally discovered this...
    Originally I was not going to write this post, but after I found out that several other people didn't know this I figured what the heck,...
  • Your lack of constraints is disturbing
    It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
  • Ten SQL Server Functions That You Hardly Use But Should
    Below are 10 SQL Server functions that are hardly used but should be used a lot more I will go in more detail later on but here is a list of...
  • Use T-SQL to create caveman graphs
    I found this technique on Rich Benner's SQL Server Blog:  Visualising the Marvel Cinematic Universe in T-SQL  and decided to play arou...
  • A little less hate for: String or binary data would be truncated in table
    The error String or binary data would be truncated is one of the more annoying things in SQL Server. You would insert some data and you wou...
  • Some cool SQL Server announcements SQL Graph, Adaptive Query Plan, CTP1 of SQL vNext, SQL Injection detection
    There were a bunch of cool announcement at the SQL QA and chalk talk sessions at the PASS Summit Here are the people presenting th...
  • Convert Millisecond To "hh:mm:ss" Format
    This question was posted in the Transact-SQL MSDN Forum You have a column in your table that stores duration in milliseconds You would like ...
  • How to update 2 tables with 1 statement in SQL Server..the hard way....
    Every now and then you will get someone asking how to update two tables with one statement in SQL Server. The answer is usually, no that ...
  • SQL Server 2017: SQL Graph
    With the CTP2 build of SQL Server 2017, you now have the ability to use SQL Graph I decided to play around with it a little, I based the...

Labels

SQL Server 2005 (80) SQL Server 2008 (62) SQL Server 2000 (40) tip (29) SQL Server (24) Teaser (21) SQL Server 2016 (20) Book (18) Funny (18) Howto (16) Interview (16) trick (15) Gotcha (14) Links (13) BestPractices (12) Goofing Around (12) sad but true (12) CTP (11) Podcast (11) Service Pack (11) Tools (11) Best Practices (10) SQL Functions (10) Linux (9) SQL Server vNext (9) SQLPASS (9) Tips and Tricks (9) unit testing (9) tSQLt (8) LINQ (7) Performance (7) SQLPass2016 (7) T-SQL (7) Video (7) Visual Studio 2008 (7) unit tests (7) ASP.NET (6) Dates (6) Extreme Programming (6) Google (6) Humor (6) Katmai (6) Learning (6) Nulls (6) Performance Tuning (6) SSIS (6) Security (6) non-technical (6) weekend reading (6) Blog (5) Celko (5) Indexes (5) OLAP (5) SSMS (5) Whitepaper (5) rant (5) sql server 2017 (5) Agile (4) Ajax (4) Code (4) Dynamic Management View (4) Functions (4) SQL Server on Linux (4) Scrum (4) SharePoint (4) sql server 2012 (4) sqlsummit (4) what is new in SQL Server 2016 (4) Books On Line (3) Business Intelligence (3) DMV (3) Data Dude (3) Data Warehouse (3) Datetime (3) Errors (3) Feature Pack (3) Hacks (3) Indexing (3) Integration Services (3) MIX07 (3) Movie (3) MySQL (3) Oracle (3) Orcas (3) Python (3) Reporting Services (3) Review (3) SQL (3) SharePoint Server (3) Soccer (3) System Functions (3) TRUNCATE (3) Visual Studio (3) Wiki (3) XLINQ (3) career (3) constraints (3) github (3) pass summit (3) sql server 2014 (3) stored procedures (3) twitter (3) ubuntu (3) videos (3) .NET (2) .NET 3.5 (2) Administration (2) Analysis Services (2) BackToBasics (2) Better Developer (2) Bug (2) Bulk Copy (2) Christmas (2) Cool Stuff (2) Croatia (2) DELETE (2) DLINQ (2) Data (2) Denali (2) Django (2) Encryption (2) England (2) Euro 2008 (2) Excel (2) Forum (2) FoxPro (2) Hotfix (2) Identity Theft (2) Internals (2) Math (2) Microsoft Office (2) NULLIF (2) News (2) PostgreSQL (2) Puzzles (2) Ruby (2) Ruby on Rails (2) SQL Series (2) SQL Server 2005 Analysis Services (2) SQL Server 2005 Express (2) SQLPass2014 (2) Samples (2) Screen Cast (2) Silverlight (2) Sopranos (2) Spam (2) To Read (2) Top Ten (2) Trigger (2) Triggers (2) Vista (2) Visual Studio 2005 (2) Visual Studio Orcas (2) Webcast (2) Windows Server 2008 (2) XAML (2) Xmas (2) bcp (2) books (2) bugs (2) bulk insert (2) database (2) files (2) flickr (2) foreign keys (2) pitfalls (2) r (2) ranking (2) scripts (2) seattle (2) sql server 2019 (2) temp tables (2) tsql2sday (2) views (2) windowing functions (2) .NET Micro Framework (1) 2018 (1) Access (1) Alexa (1) Amazon (1) Amoxicillin (1) Announcement (1) Apache (1) Astoria (1) Azure SQL DB (1) Backup (1) Badnja Vecer (1) Beta (1) BizTalk (1) C# (1) COALESCE (1) CSLA.NET (1) CSS (1) Cadeaux (1) Change Data Capture (1) Clerks II (1) CodePlex (1) Collations (1) Computing in The Cloud (1) Crazy Stuff (1) Critical (1) DBCC (1) DDL (1) Dimensional Modeling (1) Dinner (1) Documentation (1) Dow jones (1) Download (1) Duke Nukem (1) Duke Nukem Forever (1) Entourage (1) Excel 2007 (1) FUD (1) Family (1) Federated Databases (1) Fifa (1) Food (1) Framework (1) Framwork (1) GNET (1) Game (1) Hardware (1) High Availability (1) Horror (1) IE8 (1) IIS (1) IO (1) In the cloud computing (1) Internet Explorer 8 (1) Jasper (1) Java (1) Job (1) Joe Celko (1) Kids (1) LAMP (1) LINQ to SQL (1) LINQPad (1) Lambda Expressions (1) Lord of the Rings (1) MIX08 (1) MSDN (1) MVP (1) Malware (1) Map (1) Merge (1) Microsoft (1) Microsoft .NET (1) Microsoft Office PerformancePoint Server 2007 (1) NEWID() (1) NEWSEQUENTIALID() (1) NYC (1) News Corp (1) Newsgroups (1) Notification Services (1) OSS (1) OUTPUT (1) Obscure Stuff (1) Office (1) Opera (1) Operators (1) Outlook (1) Oxycodone (1) Oxycontin (1) PHP (1) Parenting (1) Partitioned Views (1) Patch (1) Perl (1) Pics (1) Porn (1) Poster (1) PowerPoint (1) Pownce. (1) Presents (1) Programming (1) Questions (1) Recovery Models (1) Red Gate (1) Refactoring (1) Root Canal (1) Roxicodone (1) SCHEMABINDING (1) SEO (1) SQL Controversy (1) SQL Injection (1) SQL Myth (1) SQL Server 2007 (1) SQL Server Data Services (1) SQL Server Data Services Architecture (1) SQL Server Integration Services (1) SQL Server Reporting Services (1) SSAS (1) SSDS (1) Sample Code (1) Samples. Code (1) Schemas (1) Search (1) Service Broker (1) Services (1) Showtime (1) Snowflake Schema (1) Software (1) Source Control (1) Spring (1) Star Schema (1) Star Wars (1) StrataFrame (1) Subversion (1) TIL (1) TV (1) Table valued parameters (1) Teaser.NULL (1) Tech·Ed 2007 (1) TempDB (1) Test (1) Time (1) Tortoise (1) Trace (1) Transactions (1) Tuning (1) UPSERT (1) Uefa (1) Update (1) Version Control (1) Virtual PC (1) Visual Studio Team Edition (1) WPF (1) WTF (1) Web Standards (1) Web2.0 (1) Webchat (1) Windows Server (1) WorldCup 2010 (1) XP (1) analysis (1) analytical functions (1) april fools (1) art (1) blogging (1) blunders (1) book review (1) build (1) build2017 (1) case (1) clustered index (1) code library (1) commodore (1) compression (1) conference (1) connect (1) connections (1) csv (1) cte (1) cursors (1) data modeling (1) data science (1) data types (1) database design (1) failure (1) features (1) flickrvision (1) formats (1) formatting (1) graph (1) iPhone (1) introductory (1) joins (1) left join (1) lessons (1) maintenance (1) manhattan (1) max (1) memoryYou can (1) metrics (1) mistakes (1) music (1) new york city (1) open data (1) phishing (1) powershell (1) prime numbers (1) queries (1) query plan (1) rdbms (1) right join (1) rss (1) sample databases (1) scripting (1) sessions (1) silly (1) sports (1) sql graph (1) sqlserver 2008 (1) static code analysis (1) tech (1) temporal data (1) twittervision (1) uniqueidentifier (1) utilities (1) variables (1) webcasts (1)
I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside..
DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you
"
Awesome Inc. theme. Powered by Blogger.