Tags | Domains | Searches | Statistics | Options | Advanced Search
|
Tags | Domains | Searches | Statistics | Options | Advanced Search |
dannyr - Oct 7, 2008
i am always surprised to learn that many really helpful features of SQL server are not known to the general SQL server community ,from my experience one of those nice “unknown” features is getting Blocking information …
Also tagged: sql server, sql server 2005, sql server 2008, sql 2008, itpro
dannyr - Oct 7, 2008
a new tool i stumbled upon in www.codeplex.com which is called “Sql Nexus Tool” ,i paste here the tool description : What is SQL Nexus? SQL Nexus is a tool that helps you identify the root cause of SQL Server …
Also tagged: sql server, sql server 2008, sql 2008, itpro
dannyr - Oct 7, 2008
a nice feature i wanted to share is the ability to run a query on multiple servers\instances in SSMS 2008 ,first you open the registered servers pane In SQL Server 2008, you can administer multiple servers by …
Also tagged: sql server, sql server 2008, sql 2008, itpro
dannyr - Sep 28, 2008
When searching for resource-intensive queries, we can use the sys.dm_exec_query_stats and sys.dm_exec_requests ,this dynamic management views already where introduced in SQL server 2005,in SQL Server 2008 there are a …
Also tagged: sql server 2008
dannyr - Sep 17, 2008
In My previous blog I showed how to use module signing for preserving execution context, in this blog I will show a secured way to call remote stored procedure without having to give extended permissions to users …
dannyr - Sep 17, 2008
SQL Server 2005 introduced the capability to sign modules within the database, such as stored procedures, functions, triggers, or assemblies, how can we use module signing for our benefit? The most obvious benefit of …
Also tagged: sql server 2005, sql 2008
dannyr - Sep 17, 2008
In the last couple of months I have delivered a few presentations on SQL server 2008 and among other things I have demonstrated transparent data encryption in SQL server 2008 (TDE), a lot of people get confused from …
Also tagged: sql server 2008
Pavel's Blog - Sep 17, 2008
For all XNA lovers: XNA 3.0 Beta has been released! Here are the main changes and new features (from the XNA team blog): You can download it here. Zune Compatibility with the upcoming Zune 3.0 Firmware release …
Pavel's Blog - Sep 11, 2008
Another update to my CLR Explorer tool. Changes in this release: A toolbar... Thread call stack includes method signature and values (for the simple types). No generics yet. Can create a dump file on a selected …
Also tagged: dev, clr explorer
Pavel's Blog - Aug 27, 2008
Every delegate has the inherent ability to be called asynchronously. When a delegate is defined, the compiler creates a new class inheriting from MultiCastDelegate and synthesizes a constructor and 3 methods: The …