Using PowerShell and a little bit of .NET Framework and XML knowledge, it is possible to delve a little deeper into the information which is potentially available to you from Twitter. Jonathan explains about Twitter and shows how to use Powershell to access twitter automatically.
2009-08-14
2,643 reads
It is often the case in large DBA teams where multiple DBAs can administer the same SQL Servers and it is not apparent to one DBA the importance of some of the jobs to another DBA. In this tip I show how you can be alerted of these changes.
2009-08-13
3,880 reads
The Transfer SQL Server Objects Tasks is a very useful tool in SQL Server 2005 to move objects between SQL Server Instances.
2009-08-13
2,578 reads
Get the inside scoop on SSRS 2008 with Michael Lisin and Jim Joseph, co-authors of the new book, "Microsoft SQL Server 2008 Reporting Services Unleashed."
2009-08-12
4,114 reads
Sometimes when working with SSIS you need to add or change settings in the .NET application configuration file, which can be a bit confusing when you are building a SSIS package not an application. First of all lets review a couple of examples where you may need to do this.
2009-08-12
3,085 reads
The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of the database. Apart from the space savings, data compression provides another benefit: Because compressed data is stored in fewer pages, queries need to read fewer pages from the disk, thereby improving the performance of I/O intensive workloads. However, extra CPU resources are required on the database server to compress and decompress the data, while data is exchanged with the application. Therefore, it is important to understand the workload characteristics when deciding which tables to compress.
2009-08-11
2,717 reads
In SQL Server 2000 and onwards there are INSTEAD OF triggers that can be used to carry out such tasks. Although these types of triggers can be used in a number of scenarios their primary function is to perform DML operations through such views. This tip shows how to use INSTEAD OF triggers to handle these DML operations on views.
2009-08-11
3,382 reads
Learn the difference between push and pull subscriptions and how to determine the best placement for SQL Server replication's Distribution Agent
2009-08-10
3,198 reads
Continuing our discussion covering T-SQL best practices, this article focuses on how to optimize writing a jack-of- all-trades stored procedure (SP).
2009-08-10
9,037 reads
Many famous geeks work away at their programs without considering the wider implications of what they, and others, are doing. Richard Stallman isn't like that. Richard (rms) is one of the great brains behind Linux distros, as he wrote the GNU compilers and GNU debugger. He is driven by strong opinions about the nature of free software, and the restrictive nature of software copyright. We sent our intrepid reporter, Richard Morris, to find out if Richard Stallman really required journalists to read parts of the GNU philosophy before an interview, for "efficiency's sake".
2009-08-07
2,874 reads
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Max PK Length
Comments posted to this topic are about the item My experience using the GitHub...
Comments posted to this topic are about the item The Microsoft SQL Year in...
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers