Browse by Tags
All Tags » SQL Server 2008 ( RSS)
-
|
The law of unintended consequences is an amazing thing. When I posted Dirk Gubbels’ holiday greeting last week, I very quietly snuck in a new format for displaying source code, a formatting plug-in that was recommended in an internal discussion group...
|
-
|
"Para dar suporte às equipes de corrida, precisamos de três qualidades de um banco de dados: desempenho, integridade e robustez. Se você puder encontrar as três, terá um vencedor. E o SQL Server 2008 vence nos três quesitos." Peter van Manen...
|
-
|
Courtesy of SQL Ranger Dirk Gubbels and my TechEd EMEA track owner Gunther Beersaerts (both of whom passed this along in the last 36 hours), here’s a query for the season. Run this query in the master database on a SQL Server 2005 or SQL Server 2008 instance...
|
-
|
It’s Christmas Eve and the last day of my virtual advent calendar on SQL Server 2008.. Hopefully the last 23 posts have given you some idea of what’s in SQL Server 2008 so I thought it might be useful to conclude with a word on upgrade. Firstly SQL Server...
|
-
|
Day 23 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Filestream isn’t one of the new data types in SQL Server 2008 it a variant of varbinary(MAX), and it is Microsoft’s solution to the problem of storing large unstructured data...
|
-
|
Day 22 of my virtual advent calendar, about stuff I like in SQL Server 2008.. SQL Server 2008 now has data types to store points lines and polygons in 2 spatial data type, Geometry and Geography. I have already posted quite extensively on spatial data...
|
-
|
Day 18 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Consolidation has become synonymous with virtualization, but even hardcore VMWare addicts and VMWare themselves advise that databases are one of the last targets of a virtualisation...
|
-
|
Day 20 of my virtual advent calendar, about stuff I like in SQL Server 2008.. The accidental DBA is a DBA who ends up looking after SQL Server as part of a number of other duties e.g. Exchange admin, developer etc. This often occurs because SQL Server...
|
-
|
Day 19 of my virtual advent calendar, about stuff I like in SQL Server 2008.. I often get asked how much faster is SQL Server 2008 than SQL Server 2000, what impact will virtualisation have on my performance, and my answer in fine Microsoft tradition...
|
-
|
Il log shipping : SI. Posso usare sia la configurazione sincrona che asincrona del DB mirroring, entrambe configurate con il full recovery mode, che è un requisito del DB mirroring. Sia il principal che il mirror devono essere configurati come primay...
|
-
|
Day 18 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Rounding out ways of keeping an eye on what’s happening to your data in SQL Server 2008 is the new auditing feature in Enterprise edition. As the name suggest it’s there...
|
-
|
Day 17 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Today’s topic is the confusingly named change tracking i.e. nothing to do with Change Data Capture (CDC) I mentioned in my last post. CDC is only in enterprise edition only...
|
-
|
Technorati Tags: SQL Server 2008 , Upgrade , Technical Reference Guide A common request from customers is for information about upgrading from SQL Server 2000/2005 to SQL Server 2008. In conjunction with Solid Quality Mentors, Microsoft has published...
|
-
|
La decisione di migrare a Sql Server 2008 da una versione precedente (2000, 2005) comporta una prima scelta fondamentale : Upgrade in-place (l'istanza viene aggiornata a Sql Server 2008) o side-by-side (viene creata una nuova istanza sullo stesso...
|
-
|
Il failover cluster ? SI. Le configurazioni possibili sono 3 : 1 - High-safety mode CON failover automatico (istanza witness presente, modalità sincrona : http://msdn.microsoft.com/en-us/library/ms179344.aspx ) E' consigliata una configurazione a...
|
-
|
Service Pack 3 for Microsoft SQL Server 2005 (build number 9.00.4035 ) is now available and ready to download at http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en . A complete List of the...
|
-
|
Day 16 of my virtual advent calendar, about stuff I like in SQL Server 2008.. One of the main hurdles in refreshing a data warehouse is to work out what’s changed since the last refresh. If you’re lucky the source will have a last modified date...
|
-
|
Day 15 of my virtual advent calendar, about stuff I like in SQL Server 2008.. If there were no issues with data quality in data warehouses I would have completed many of my BI projects in a third of the time. The client would always insist they...
|
-
|
Day 14 of my virtual advent calendar, about stuff I like in SQL Server 2008.. If it aint broke don’t fix it, is probably best aimed at Integration Services in SQL Server 2008. So what was ‘fixed’? The most important thing was the performance of...
|
-
|
Day 13 of my virtual advent calendar, about stuff I like in SQL Server 2008.. The SQL Group by clause has been around since I can remember, but in SQL Server 2008 we know have grouping sets. Imagine you wanted to sum sales amount from the adventure...
|
-
|
I had a couple of extra minutes today and found this post on Linchi Shea’s blog ; I wanted to commend to all of you who’ve taken in the programming methodology and set-based thinking discussions in this little corner. While I disagree some with the point...
|
-
|
This is another one of those tricks that’s been available since the earth was cooling, but I just discovered it recently. So, here’s a history lesson in the form of a small T-SQL script, with the moral contained in the title of this post: set nocount...
|
-
|
Day 12 of my virtual advent calendar, about stuff I like in SQL Server 2008.. One of the frustrations I used to have with Reporting Services was to decide whether to use a table or a matrix data control, and if I got too far in to a design and it turned...
|
-
|
Ho approfittato di questi giorni un più “tranquilli”, dopo TechDays WPC, per consolidare la lista dei blogger e dei blog attivi di Microsoft Italia. Molti colleghi e differenti Team sono impegnati ad utilizzare il blog come strumento di comunicazione...
|
-
|
Day 11 of my virtual advent calendar, about stuff I like in SQL Server 2008.. …and I mentioned redesigning charts in my last post and the best answer might be to get your users to do it for themselves in Report Builder 2. Leaving you (the DBA BI expert...
|
More Posts Next page »
|
|