|
|
Browse by Tags
All Tags » SQL Server 2005 (RSS)
Showing page 1 of 20 (395 total posts)
-
Thanks to yet another kick-in-the-pants from Jimmy May (did he play soccer as a youth?) the Pond’s Laws Home Page is now live. Jimmy wanted to find all of Pond’s Laws in one place, and now he (and you) can. There’s also a link to the new page in the A Bit More From Me section to your left (if you’re reading on the blog site). Keep those suggestions coming.. even if your name isn’t Jimmy May! -wp this copyrighted material was originally posted at http://blogs.technet.com/wardpond . the author and
-
This page will serve as a compendium of Pond’s Laws posts. The individual posts which promulgate the laws may be found as follows: Pond's First through Tenth Laws Pond's Eleventh Law Pond's Twelfth Law Pond's Thirteenth Law Pond's Laws of System Design (or, How To Be A Competent Professional In An Irrational World) 1. This list is perpetually a work in progress. It is never complete. No, this is not because it parallels my perception of how software development processes work. It's because the longer
-
You might have heard about this somewhere else.. but Windows 7 was launched today . I recently got an upgraded laptop from my employer, upon which I installed Windows 7. Both the machine and the software are quite remarkable. First, the machine, so you can see how sweetly I’m riding these days, is an HP EliteBook 8530w (2.8gHz Intel® Core™ 2 Duo Processor T9600, 8gB RAM, 250gB hard disk, and all the extras which are typical these days). What’s really incredible is how the lighter footprint of Win7
-
Herewith, a discussion of the emergence of Pond’s Thirteenth Law (if you need to catch up, here are Laws One through Ten , Eleven , and Twelve , as well as three ruminations on the implications of Pond’s Seventh Law ).. One of the great things about my job is that I get to spend an embarrassing amount of time having conversations with really smart people. The next couple of posts I’ve got planned are the product of conversations I’ve either had or eavesdropped on (via email). My primary project these
-
Two Microsoft folks frequently featured in this space, Microsoft Certified Masters Jimmy May and Jens Suessmeyer , have joined forces to bring to the world SQLIOSimParser, a tool to parse and interpret the XML output of the Bob Dorr’s SQLIOSim testing tool. Jimmy says Jens did most of the heavy lifting, but most of the heavy reading is found in Jimmy’s post on the tool. If you’ve ever plodded through a SQLIOSim output file, you’ll be very excited to hear about and use this tool. Thanks to Jens and
-
E’ possibile eseguire la semplice query seguente per recuperare l’informazione. SELECT S.session_id FROM sys.tcp_endpoints E JOIN sys.dm_exec_sessions S ON E.endpoint_id = S.endpoint_id WHERE E.name = 'Dedicated Admin Connection' Ricordo che su Sql Server Express Edition è necessario avviare l’istanza con il trace flag 7806 per rendere possibile l’uso delle sessioni DAC .
-
After a long hiatus , Pond’s Laws of System Design (or, How to Be a Competent Professional in an Irrational World) returns. Thanks to Jimmy May for a kick-in-the-pants on this topic several months ago; I hope he’ll understand why I just had to wait until right now to publish this post (the clue lies in a very careful examination of the datetime stamp on this post vis a vis our topic).. I know you’re asking yourself.. Why would I practice looking for an impossible poker hand in front of my (great-(great-(great-)))grandboss?
-
Courtesy of Jens Suessmeyer comes this little gem purloined from an internal discussion; cut-and-paste this into SQL Server Management Studio and see if you can answer the questions in the comments before you execute the script: -- create and populate a table variable DECLARE @Demonstration TABLE ( ID INT IDENTITY ( 1 , 1 ), Col1 INT , Col2 INT , Col3 INT ) INSERT @Demonstration ( Col1 , Col2
-
Windows Server 2003 / SQL Server 2005 환경에서 2-node Active / Passive 클러스터 구축을 위한 방법을 자세히 소개해 드립니다. 첨부 문서 참조 : SQL Server 2005 클러스터 구성 (SP2 설치)
-
Windows Server 2003 / SQL Server 2005 환경에서 2-node Active / Passive 클러스터 구축을 위한 방법을 자세히 소개해 드립니다. 첨부 문서 참조 : SQL Server 2005 클러스터 구성 (RTM 설치)
-
Windows Server 2003 / SQL Server 2005 환경에서 2-node Active / Passive 클러스터 구축을 위한 방법을 자세히 소개해 드립니다. 첨부 문서 참조 : Windows Server MSCS 구성 및 MSDTC 리소스 추가
-
Windows Server 2003 / SQL Server 2005 환경에서 2-node Active / Passive 클러스터 구축을 위한 방법을 자세히 소개해 드립니다. 첨부 문서 참조 : 클러스터 구성을 위한 Active Directory 구성
-
Ci sono diversi metodi per farlo, come utilizzare la stored procedure sp_helptext , fare una query sulla vista sys.system_sql_modules o una chiamata alla funzione object_definition . Di seguito un esempio con sys.tables : -- SP_HELPTEXT sp_helptext 'sys.tables' -- OBJECT_DEFINITION SELECT OBJECT_DEFINITION ( object_id ( 'sys.tables' )) -- SYS.SYSTEM_SQL_MODULES (recupero schema_id e object_id dell’oggetto) SELECT schema_id FROM sys.schemas WHERE name = 'sys' SELECT object_id FROM sys.system_views
-
Per individuare gli utenti orfani (senza un login associato) di un database è possibile utilizzare la stored procedure sp_change_user_login utilizzando il parametro @action ed impostandolo su Report . Di seguito un esempio del database AdventureWorks che ha l’utente Customer3 che non è associato a nessun login sull’istanza: Per mappare un utente del database ad una login è invece meglio utilizzare l’istruzione T-SQL ALTER USER .
-
With SQLRAP 2.5 out the door a couple of weeks ago, I’ve been free to turn to another project, SIPA, an internal effort to automate storage and retrieval of our group’s diverse intellectual property catalog. I’m acting as both the database architect and one of the database implementers on the project. This is my first significant from-scratch development effort under SQL Server 2008, and I’m incredibly impressed: the MERGE statement, which I among many other have been asking for since shortly after
-
Ho raccolto in questo post i documenti utili nel caso sia necessario rinominare un server standalone che esegue Sql Server o un Virtual Server in caso di configurazioni in Failover Cluster. NOTA : Sql Server 2000 non supporta questa operazione per i virtual server clustered. Sql Server 2008 standalone http://msdn.microsoft.com/en-us/library/ms143799.aspx Considerazioni : SQL Server does not support renaming computers that are involved in replication, except when you use log shipping with replication.
-
Actually, I’m about a month late to the party on this one.. but I’ve been busy.. Cumulative Upgrade 4 for SQL Server 2005 Service Pack 3 is available for download here . The SQL Server Release team discusses the SP3 release here and the SP2 release here . Aaron Bertrand has a nice discussion here of issues addressed in each release. If you need it, go get it! -wp this copyrighted material was originally posted at http://blogs.technet.com/wardpond . the author and his employer are
-
Windows 7 and Windows Server 2008 R2 releases are just around the corner. Are you thinking about deploying these new operating systems? Get a head start with Microsoft Assessment and Planning Toolkit 4.0 to help you determine readiness of your machines and accelerate the deployment planning process. Over 690,000 Microsoft customers and partners including Costco Wholesale Corporation, Continental Airlines, and Banque de Luxembourg have already downloaded and/or used this toolkit to date. Today at
Posted to Microsoft Assessment and Planning Toolkit Team Blog (Weblog) by mapblog on July 13, 2009
Filed under: case studies, Desktop Deployment, Desktop Deployment Tools, Hardware Assessment, IT Management, IT Managers, MAP, MAP Toolkit, Microsoft Assessment and Planning, News, PC Security, RTM, RTM Announcements, security, Server Virtualization, SQL, SQL Server 2008, Virtualization, Windows Server 2008 R2 Hyper-V, Windows Vista, WPC 2009, SQL 2000, SQL 2008, Deployment Tools, Hyper-V, case study, Windows 7 Deployment Tools, Microsoft, Windows Server 2008 R2, Virtual Server 2005 R2, virtualisation, App-V, Solution Accelerators, Windows, IT Professionals, Green IT, Windows 7, Windows Vista Hardware Assessment, Windows Vista Readiness Assessment, Anti-Spyware, Anti-Virus, SQL Server 2005
-
Now go away, or we shall taunt you a second time. - John Cleese as a French knight (picture at left); Monty Python and the Holy Grail One of the reasons I started blogging over four years ago was my conviction that the coding challenges with which my employer was presenting me, while stimulating and challenging, were far from unique. I hate to say “I told you so,” but then I didn’t tell you , I told me , so it would be both pointless and wrong to say “I told you so.” But, “I told me so” doesn’t sound
-
Vi segnalo un Virtual Lab di 90 min. sulla protezione di Sql Server con System Center Data Protection Manager 2007 : http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032407492&EventCategory=3&culture=en-US&CountryCode=US Vi ricordo anche alcune delle principali caratteristiche di DPM 2007 applicate a Sql Server : Enhanced SQL Server 2008 protection, including the addition of new protection capabilities for mirrored databases, support for parallel backups of databases
1 ...
|
|
|
