SqlServerKudos - Stories tagged with SQL Server 2008

SQL Server 2008

atom rss
2
kudos
spam Kudos Remove

Upgrade but Avoid v1.0 Features
published 1015 days, 21 hours, 47 minutes ago posted by sasa 1020 days, 17 hours, 27 minutes ago
Monday, August 10, 2009 2:33:32 PM GMT Wednesday, August 05, 2009 6:53:42 PM GMT
Upgrade but Avoid v1.0 Features
August 5, 2009 · Posted in SQL Server  Holding off on the newest features sounds like a no brainer especially when the next SQL Server release seem a million years away and is BI focused. In the reality, I was partitioning tables the first night we upgraded to SQL Server 2005. I could not replace TEXT with VARCHAR(MAX) fast enough. Some DTS packages got hit with the shamwow and emerged in SSIS. All of these changes broke stuff. None of these were necessary. A straight upgrade of the engine would hav... (more)
category: Management | clicked: 3 | comment | | source: jasonmassie.com
tags: bugfix, DBA, SQL Server 2008, Upgrade
1
kudos
spam Kudos Remove

The SQL Server 2008 Developer Training Kit
published 1017 days, 21 hours, 50 minutes ago posted by sasa 1022 days, 16 hours, 36 minutes ago
Saturday, August 08, 2009 2:30:46 PM GMT Monday, August 03, 2009 7:44:57 PM GMT
The SQL Server 2008 Developer Training Kit
Want some free training? I think Microsoft does an amazing job of getting training out for free. If you need a boost for your career, are just starting out, or need to re-tool after a layoff, or if you just want to become more familiar with the latest version, you can access these resources to learn more. Here's one that I really like - you get examples, setup for hands-on-labs and more, all free. It also works with the Express Editions of SQL Server 2008 and... (more)
category: News | clicked: 2 | comment | | source: blogs.msdn.com
tags: SQL Server 2008, Training
1
kudos
spam Kudos Remove

MapPoint Add-in for SQL Server
published 1022 days, 38 minutes ago posted by sasa 1025 days, 16 hours, 18 minutes ago
Tuesday, August 04, 2009 11:42:41 AM GMT Friday, July 31, 2009 8:02:20 PM GMT
MapPoint Add-in for SQL Server
Nice :) If you have MSDN you can download MapPoint Europe or US or get the trial from the link below - will be trying this out tonight View and edit your SQL data on a map... (more)
category: News | clicked: 3 | comment | | source: sqlblogcasts.com
tags: MapPoint, Spatial, SQL Server 2008
1
kudos
spam Kudos Remove

Code Collapse and Expand Feature in SQL Server Management Studio 2008
published 1023 days, 29 minutes ago posted by sasa 1026 days, 18 hours, 33 minutes ago
Monday, August 03, 2009 11:51:18 AM GMT Thursday, July 30, 2009 5:47:17 PM GMT
Code Collapse and Expand Feature in SQL Server Management Studio 2008
Code Collapse and Expand Feature in SQL Server Management Studio 2008 In SQL Server Management Studio 2008, whenever you have a "block" of code (BEGIN....END, etc) SSMS will put a little plus-sign in the margin and allow you to "collapse" that block of code so you only see the BEGIN, not stuff underneath. If you're working with a really large set of code, that's helpful. But I got an e-mail from a friend that said her SSMS didn't do that. I was kind of surprised, since I never had to do anything to mak... (more)
category: Management | clicked: 19 | comment | | source: blogs.msdn.com
tags: DBA, Developer, Development, SQL Server, SQL Server 2008, SQL Server Management Studio, SSMS, Tips
1
kudos
spam Kudos Remove

How to insert into two tables in one statement
published 1023 days, 29 minutes ago posted by sasa 1027 days, 15 hours, 15 minutes ago
Monday, August 03, 2009 11:51:18 AM GMT Wednesday, July 29, 2009 9:05:12 PM GMT
How to insert into two tables in one statement
Today I am going to show a statement available with SQL Server 2008 and later, the MERGE command, and how it will be possible to insert into two tables within same statement. Right now, I can't see a practical use, but that might change in the future. As long as I remember this blog post exists... (more)
category: Query | clicked: 3 | comment | | source: weblogs.sqlteam.com
tags: MERGE, SQL Server 2008
1
kudos
spam Kudos Remove

Media Business Intelligence - Decentrix and BIAnalytix - Part 2
published 1029 days, 15 minutes ago posted by sasa 1029 days, 17 hours, 41 minutes ago
Tuesday, July 28, 2009 12:05:09 PM GMT Monday, July 27, 2009 6:39:57 PM GMT
Media Business Intelligence - Decentrix and BIAnalytix - Part 2
In this episode, host Kirk Evans talks with Dr. Michael Ludwich, VP of Consulting at Decentrix, where Dr. Ludwich provides a demonstration of the BIAnalytix solution. This quite an interesting demonstration, helping to show the value of BI in a media organization. In Part 1 of this interview, we talked with Wayne Ruting, CEO of Decentrix, about the importance of business intelligence in a Media & Entertainment company. Decentrix has quite a client roster, including some of the largest broadcaste... (more)
category: Analysis | clicked: 0 | comment | | source: channel9.msdn.com
tags: BI, Excel, Excel 2007, Excel Services, Office, SharePoint, SQL 2008, SQL Server, SQL Server 2008, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, SSAS, SSIS, SSRS
1
kudos
spam Kudos Remove

Media Business Intelligence - Decentrix and BIAnalytix - Part 1
published 1026 days, 9 minutes ago posted by sasa 1029 days, 18 hours, 2 minutes ago
Friday, July 31, 2009 12:11:33 PM GMT Monday, July 27, 2009 6:18:59 PM GMT
Media Business Intelligence - Decentrix and BIAnalytix - Part 1
In this episode, Kirk Evans talks with Wayne Ruting, CEO of Decentrix, about the importance of business intelligence in a Media & Entertainment company. Decentrix has quite a client roster, including some of the largest broadcasters, cable operators, and telcos in the US. We talk about why BI matters, how BI is not simply providing reports in a transactional application, and we learn more about Decentrix and their BIAnalytix offering. I learned a lot during this interview about the importance of B... (more)
category: Analysis | clicked: 1 | comment | | source: channel9.msdn.com
tags: BI, Excel, Excel 2007, Excel Services, MOSS, MOSS2007, Office, SharePoint, SQL 2008, SQL Server 2008, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services
1
kudos
spam Kudos Remove

Aaron Bertrand : Oh, the horror! Please stop telling people they should shrink their log files!
published 1026 days, 9 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 1029 days, 20 hours, 23 minutes ago
Friday, July 31, 2009 12:11:33 PM GMT Monday, July 27, 2009 3:57:49 PM GMT
Aaron Bertrand : Oh, the horror! Please stop telling people they should shrink their log files!
I realize that there are some cases where, in an emergency, you need to shrink a log file because it took over the drive.  In SQL Server 2005 and earlier, you could get out of the jam quickly, by issuing a BACKUP LOG WITH TRUNCATE_ONLY (followed by DBCC SHRINKFILE).  In SQL Server 2008, this "feature" within BACKUP LOG is no longer available, and with good reason; however, there are other - shall we say, "clever" - ways to achieve this.  But too many people pass this advice off casually, and this gives p... (more)
category: Management | clicked: 3 | comment | | source: sqlblog.com
tags: LogFile, LOGS, SQL Server 2005, SQL Server 2008
1
kudos
spam Kudos Remove

The Rambling DBA: Jonathan Kehayias : Digging into the SQL Plan Cache: Finding Missing Indexes
published 1027 days, 13 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 1029 days, 20 hours, 39 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 3:41:35 PM GMT
The Rambling DBA: Jonathan Kehayias : Digging into the SQL Plan Cache: Finding Missing Indexes
This is one of those topics I planned to blog about a long time ago, but never actually got around to it, and consequently I keep having to hit search engines to find the code I provided in a forums post when I need to use it again.  A while back, I helped fellow SQL enthusiast Jeremiah Peschka (@peschkaj) out via twitter with finding plans that included missing index information in them.  Then a bit later I used the same code on a Forums Post and then again with Michelle Ufford (@sqlfool) who actually t... (more)
category: Analysis | clicked: 0 | comment | | source: sqlblog.com
tags: analysis, Performance, plan cache, SQL Server 2005, SQL Server 2008
2
kudos
spam Kudos Remove

SQL Update Statement: How to Create a Server-Side Trace with SQL Profiler
published 1027 days, 13 minutes ago posted by http://sqlchicken.blogspot.com/http://sqlchicken.blogspot.com/ 1029 days, 20 hours, 58 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 3:22:08 PM GMT
SQL Update Statement: How to Create a Server-Side Trace with SQL Profiler
This morning on Twitter my friend (and as per request, “handsome moron”, but trust me he’s no moron) Jeremiah Peschka (Twitter) asked about scheduled traces. I suggested he do a server-side trace. Unfortunately when you Google how to do this it just tells you how to do this via T-SQL but to my dismay I didn’t see an article on how to create/set this up from SQL Server Profiler. So this will be a quick rundown on how to create your trace using the GUI of SQL Server Profiler and schedule your trace to run ... (more)
category: Management | clicked: 2 | comment | | source: sqlchicken.blogspot.com
tags: Administration, SQL Server 2005, SQL Server 2008
1
kudos
spam Kudos Remove

Apply Those Updates
published 1030 days, 7 minutes ago posted by sasa 1030 days, 10 hours, 57 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Monday, July 27, 2009 1:23:04 AM GMT
Apply Those Updates
Staying on top of patches for your applications can be important, especially when those patches can fix issues that are currently affecting your environment. I’ve run into this from time to time with where the fix for an issue is related to the current state of updates to the SQL Server instance... (more)
category: Management | clicked: 0 | comment | | source: stratesql.com
tags: SQL Server 2008, Updates
2
kudos
spam Kudos Remove

Looking for security vulnerabilities in database code
published 1029 days, 15 minutes ago posted by sasa 1031 days, 5 hours, 43 minutes ago
Tuesday, July 28, 2009 12:05:09 PM GMT Sunday, July 26, 2009 6:37:29 AM GMT
Looking for security vulnerabilities in database code
I've always been concerned with security and I've always stressed the importance of auditing the REAL user context not just the current user (see this post on EXECUTE AS and auditing). So, I generally try to avoid using dynamic string execution and if necessary create well tested/protected parameters (fyi - using QUOTENAME can be a fantasic solution to protectng identifiers as input paramet... (more)
category: Security | clicked: 1 | comment | | source: www.sqlskills.com
tags: Security, SQL Server 2005, SQL Server 2008
1
kudos
spam Kudos Remove

Internals and Query Tuning - in the Boston area October 12-16
published 1030 days, 7 minutes ago posted by sasa 1031 days, 6 hours, 41 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Sunday, July 26, 2009 5:39:43 AM GMT
Internals and Query Tuning - in the Boston area October 12-16
In case you missed Kalen's post, we're excited to announce that she will be joining us here on the East Coast in October to deliver her SQL Server 2005/2008 Internals and Query Tuning seminar. This is, to my knowledge, the most advanced public SQL Server course to be offered in the Boston area in the last 5 years, and this is the first time that Kalen has ever taught in the area. I hope that some of you will be able to take advantage of this rare opportunity to really take your SQL Server skills to the n... (more)
category: News | clicked: 1 | comment | | source: sqlblog.com
tags: Query Tuning, SQL Server 2005, SQL Server 2008, Training
Previous 1 2 3 Next