Browse by Tags
All Tags » SQL Server 2008 ( RSS)
-
|
Well, it took me long enough to figure out how to get this done, didn’t it? The good news is that I have a brand new tool in my arsenal.. the bad news is that I burned a bunch of precious rural bandwidth trying to upload this material to inappropriate...
|
-
|
La Surface Area Configuration introdotta su Sql Server 2005 non è più presente su Sql Server 2008. E' stato però introdotto un Facet sul Policy-Based Management che permette di gestire le feature come ad esempio le query remote. Le feature relative...
|
-
|
Una delle possibili applicazioni del Policy-Based Management di Sql Server 2008 è il rispetto delle naming conventions nel disegno dei database. Vediamo un semplice esempio. --creo un database di test USE [master] GO CREATE DATABASE [testPolicies] GO...
|
-
|
Segnalo un evento interessante per chi fra voi lavora in ambito Web Hosting, che si svolgerà il 12 dicembre nel Centro Congressi presso i nostri uffici di Segrate (MI). Verrà presentato il modello Software + Services e la sua importanza per gli hoster...
|
-
|
Among the interesting stuff discussed at last nights SQL community meeting at the Microsoft Campus,was a lively debate on whether to wait for SQL Server 2008 sp1. The traditional view has been to wait until sp1 because that is the stable release...
|
-
|
O Luiz Felipe Pimenta está no SQL PASS - um dos maiores eventos no mundo sobre SQL Server - e nos manda o que está acontecendo por lá: Olá Pessoal, Estou aqui no SQL PASS em Seattle, um dos maiores eventos do mundo sobre SQL Server para conferir o que...
|
-
|
It’s a simple matter to restore SQL Server backups to later versions, in fact you don’t need to do anything different but what about the other way around? I first got caught out with this back in the days of SQL Server 7 and 2000, and the basic...
|
-
|
I've made the trek across the bridge to downtown Seattle to the 2008 Professional Association for SQL Server (PASS) Community Summit. For the next three days nearly 3,000 attendees will have their brains filled with the most up-to-date and comprehensive...
|
-
|
Rilasciato oggi, informazioni disponibili qui . Share this post: Read More...
|
-
|
Good news to all of you who are IT professionals out there! Microsoft Learning team is now offering a second shot for you to take a Microsoft certification exam for free. This is a great way to get the SQL Server 2008, Windows Server 2008, Hyper-V and...
|
-
|
Thanks to Mohammed Sharaf, who passes along this post from Paul Randal’s blog regarding a corruption issue people are running into in SQL Server 2005 SP2. Here’s the money quote: The situation is this: a table with a non-unique clustered index Read...
|
-
|
Vi segnalo un white paper sulle tecniche di performance-tuning applicabili su Sql Server 2008 Analysis Services. Il documento è scaricabile qui . Share this post: Read More...
|
-
|
So here’s how it’s done.. So here’s how it’s done..I rarely know more about SQL Server than my friend Beatrice so I was surprised when I mentioned plan guides and she hadn’t heard of this new feature. I have to say this is not a big mainstream thing and...
|
-
|
During today’s session, many of you were sufficiently interested in the “ versioning of database components ” trick that I offered to post the deck from last year’s session here on the blog. Well, I’ve looked at the deck and it’s frankly a little thin...
|
-
|
For those which live or work close to Reading - there will be a UserGroup on the 20th Evening held in TVP - Microsoft Offices. Agenda: 6pm – 6:30 Registration and networking + Tea/Coffee with biscuits. Meet and greet. 6:30pm – 7 Round Table discussion...
|
-
|
I’ve attached to this message a ZIP file of the scripts from the SQL Tricks: Insights from Microsoft IT presentation I’m giving in Barcelona this week . The tricks will be familiar to long-time denizens of this space, as they’ve all been discussed here...
|
-
|
La riorganizzazione di un indice è da preferire quando l'indice non è molto frammentato. Aiuta a liberare spazio su disco compattando le pagine dell'indice ed eliminando quelle vuote in seguito alla compattazione. Viene eseguito in automatico...
|
-
|
Imagine you have a windows 2003/SQL Server 2005 cluster (active-active) and your mission is to both virtualise and maintain high availability using Hyper-V in Windows Server 2008/SQL Server 2008. This may sound odd but I was asked the question at...
|
-
|
Here we are, as promised, with some rumblings on SQL Server 2008 Resource Governor . I've played a lot with the various options which this features provides, especially in preparation of my TechEd presentation last week! Did I ever mention how much...
|
-
|
I have finally finished at TechEd after another round of interesting questions on the Microsoft SQL Server ask the experts stand. Virtualisation was the consistent hot topic and the 2 FAQ’s are: Is it supported? Yes fully in a variety of...
|
-
|
Kyle Schoonover, a former colleague in MSIT, posed the following questions in a comment on October’s cross-version database attachments post : Ward, I'm currently working in MySQL and writing conversion scripts to convert a MySQL database to a SQL...
|
-
|
Quando si devono amministrare diversi Sql Server può essere utile avere un server che faccia da contenitore per gli eventi. Configurare il forward degli eventi è molto semplice. Selezionare le proprietà del Sql Server Agent Scegliere la pagina delle Avanzate...
|
-
|
I often say that a database is only as good as the system it is running on. For example SQL Server supports 64 cores (as opposed to CPUs) because that is the limit in Windows Server, even in Windows Server 2008. However if you have been at...
|
-
|
Just discovered whilst at TechEd that Microsoft policies for SQL Server products that are running in a hardware virtualization environment are not much known as yet to the majority of the public. Therefore the PFE in me :-) wants to be sure that when...
|
-
|
Wow! Presenting at TechEd yesterday had been one of the best experiences of my life! Being in front of different customers, which work with SQL Server every day, and being able to share my experience on the field with the new great features included with...
|
More Posts Next page »
|
|