DBPedias Blog

[...] server, the volume of activity on the SQL Server, the amount of memory pressure on the SQL Server instance, and probably dozens more. If your application is tuned to the point where the speed of [...]

[...] the script in Listing 2.  This query returns a list of all of the databases on the SQL Server instance.  As you can see, in Figure 1, the query returns information on all of the [...]

[...] users Summary In this post, we answered the question of how to access securables on a SQL Server instance.  For those that aren’t familiar with securables, this is an aspect of SQL Server security [...]

[...] 10% of restriction: 3,277. Risk of doing it wrong: Guarded The number of connections your SQL Server instance can support can be found by this query and the number of open connections on the server is [...]

[...] SQLRockstar - Thomas LaRock. [...]

[...] . Top 3 Performance Killers For Linked Server Queries is a post from: SQLRockstar - Thomas LaRock The post Top 3 Performance Killers For Linked Server Queries appeared first on [...] - Thomas LaRock. [...]

[...] , but…. SQL Server: Richard Douglas is giving information about SQL Server events in UK. Thomas LaRock has been involved in a virtualization projects for almost ten years now. Kendra Little [...]

[...] Encrypted Procedures To Windows Azure SQL Database (WASD) is a post from: SQLRockstar - Thomas LaRock The post How To: Migrate Encrypted Procedures To Windows Azure SQL Database (WASD) appeared [...]

[...] 4:15-4:30 : SSMS 2012 – Tips, Tricks and New Features, by Rizwan Hassan 4:30-5:30 : SQL Server Security and Data Security, by Ross McNeely 5:30-6:00 : Announcements and prize giveaways Click here [...]

[...] the Leak I hope that this post encourages you to stop and think about the importance of SQL Server security in your environment. As a community it is our responsibility to ensure security is a [...]

[...] As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions [...]

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  These t [...]

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  These t [...]

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  These t [...]

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  These t [...]