The WorkTamer Conference
The Worktamer conference is coming to a series of cities in Canada in early 2010. If you're near Vancouver, Toronto, or Montreal, read about this one day event to help you boost your professional development.
Easy Licenses
Software licensing can be complex and confusing. Even in Windows and SQL Server, where hard limits are not enforced, people have problems determining how they should license software. Steve Jones talks about what vendors could do to help us.
Easy Licenses
Software licensing can be complex and confusing. Even in Windows and SQL Server, where hard limits are not enforced, people have problems determining how they should license software. Steve Jones talks about what vendors could do to help us.
Full Text Index Implementation in SQL Server 2005 Express Edition
Continuing our discussion, this article covers the remaining tasks necessary to implement a full-text index in SQL Server 2005 Express Edition.
Installing SQL Server 2005 Reporting Services 32-bit on a 64-bit Windows Server system
You have a Windows 64-bit server and need to install the 32-bit version of SQL Server 2005 Reporting Services on this machine. In this tip I will walk through the steps you need to take for this installation.
Interview with the Scary DBA – Grant Fritchey
With Halloween so near, we thought it would be a good time to find out more about the so-called Scary DBA, Grant Fritchey, who's been working in IT for 20 years now. He writes for SQL Server Central, Simple-Talk and SQL Server Standard, and was awarded MVP status earlier this year. We sent Richard Morris to meet him.
Speed Phreaks
A guest editorial from Phil Factor looks at the Speed Phreak competition that has been taking place recently and is quite popular. Read about the inspiration for the competition and why you might want to participate.
Easy Licenses
Software licensing can be complex and confusing. Even in Windows and SQL Server, where hard limits are not enforced, people have problems determining how they should license software. Steve Jones talks about what vendors could do to help us.
Flight or Invisibility: Which do you Choose?
A colleague of mine pointed out a great podcast called This American Life - specifically an episode with John Hodgman (the...
Pivoting, Unpivoting and Aggregating
We asked Phil Factor to write a nice simple quick-start guide about aggregation, pivoting and un-pivoting techniques. To do so, he takes us all the way from getting the data from a published source, transferring it to SQL Server, un-pivoting it, storing it in a relational table, aggregating it and finally pivoting the data in a variety of ways.
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers