|
Por Dentro Sql
Read all about SQL 2005 sp3: http://msdn.microsoft.com/en-us/sqlserver/bb895958.aspx ... and the fixlist: http://support.microsoft.com/?id=955706 Happy patching !
posted by on to ()
Some usefull extra tools/utilities/providers ...the Feature Pack for Sql Server 2008, for the october 2008 version: click here and Enjoy!
posted by on to ()
You read all about it in Wesley's blog post: http://blogs.msdn.com/wesleyb/archive/2008/09/23/cumulative-update-package-1-for-sql-server-2008.aspx
posted by on to ()
Is an interesting idea: should we virtualize Sql Server or not? Or better in which circomstances should we virtualize Sql Server ... ? Definitely a User Group evening worth !! In the mean time: learn more on virtualization on the Microsoft Virtualization Roadshow: www.getvirtualnow.be
posted by on to ()
The Windows Server System Reference Architecture is, I could not write it better than just a copy paste from the website itself: WSSRA is a detailed reference architecture, tested and proven in labs, that yields valuable implementation guidance for meeting the requirements of an enterprise. Customers can use this guidance to build...
posted by on to ()
I did not play with the Sql Server add-in for Visio 2007 yet. Curious about your reaction for those you tried it out. You can download the add-in here .
posted by on to ()
This enhancement to the object_name function is so wonderfull for the T-Sql guru's under us: The object_name() function now accepts 2 arguments: the object_id as before and as a second argument the DATABASE_ID. Isn't this wonderfull? We can finally leave the current database context, without to play around with dynamic sql. Simply...
posted by on to ()
It was a wonderfull day, full of Kimberly Trip and Paul Randal sessions. I will make it short today as they put all the slides and scripts on there website SQLskills . So only some thoughts for today: - I always thought that the default fill factor at the server level was 90%. It turned out that it is a 100%. I have to review some...
posted by on to ()
Another interesting day, full information. Once I return and I find more time, I will work out some topics. For the moment I'll provide you today with some 2-sentence topics: - Sql Server 2005: on logging in to Sql Server 2005 and you are not using any encryption, Sql Server will encrypt your login & password automatically. I...
posted by on to ()
Today, some nice-to-know's - Sql Server 2005 SP3 (not known yet when it will come out) will probably contain an instruction to do an active checksum verification on all pages of a database - Sql Server 2008 CTP (November): * What concerns the features about Transparant Data Encryption in Sql Server 2008: Tempdb will (implicitly)...
posted by on to ()
As this is a technical blog I will not give a report of this night, so after only 4 hours in bed: What do I remember from yesterday? First half of the day, community work, nice conversations with other peers. And a lot of Belgians, we were 6 or 7! Last half of the day was more sql related. I missed the keynote so I went to Francois...
posted by on to ()
We all know that the Management Console has sometimes its own logic ... Well, if you are working with database roles and want to give a user only the db_DDLAdmin role, this user will not be able to change the structure of a table using the Management Console. Glad to say, that with T-Sql you will be able :-) This behaviour is remarked...
posted by on to ()
The company Consuran is organizing a 3-day workshop about performance on Sql Server 2005. The workshop is given by R. Meyyappan . He is really good in the performance stuff. When I followed the workshop some time ago, I got more insight into the internals of Sql Server 2005. For this reason I want to share the fact that he is comming...
posted by on to ()
It seems like a déjà vue, migrating Oracle data to Sql Server. This time, some Oracle 10g tables (running on an Itanium server) to be migrated to Sql Server 2005 (temporary running on the same Itanium). I thought, piece of cake, creating a l inked server using "Oracle Provider for OLE DB" (the only provider currently available on...
posted by on to ()
Today, I was "lucky" to deal with a suspect database on a Sql Server 2000 SP4. Always a little bit targeting to get it solved, isn't it? This time, the database would not recover because of a torn-page detection in the data-file. After having taken an off-line backup (on-line backup on a suspect database does not work), I tried a...
posted by on to ()
|