(Denis Gobo) In Query Analyzer you can save a lot of time by using this trick instead of typing all the column names of a table Hit F8, this will open Object Browser Navigate to DatabaseName/TableName/Columns Click on the column folder and drag the column folder into the Code Window Upon r
Other News
Microsoft’s Lineup of SQL Server Related Webcasts for October 2007
Five new webcasts are scheduled for October, covering such topics as “Advanced Manageability for SQL Server 2008 Analysis Services”, “Tuesday Teasers Webcast Series – SQL Server 2008” and more.
Changing the name of your SQL Server
(Steven Warren) Have you ever had to change the name of a server that has SQL Server installed on it? If you anwered yes, did you know that you also have to change the name in SQL Server? Here are the steps to perform the change.
Quantifying Text differences in TSQL
(William Brewer) When you compare two pieces of text, or strings, in SQL Server in an expression, you will get just get a value of ‘true’ returned if the two were the same, ‘false’ if they were not, or ‘null’ if one of the pieces of text was null.
DBA Responsibilities for Data Uses
Last Day To Catch the Current SelectViews SQL Server Show …before tomorrow’s show posts. Watch it here. (Don’t forget, you can win $200 – congrats to our latest winner, Donna M.!) Webcast Today Moving from SQL Server 2000 to SQL Server 2005 Security We’ll look into the differences between the approaches to security, how they apply to your database, the […]
The Eternal DBA Conflict
New SQLonCall Show Is Live In this week’s show, Chris talks about how to get started on the job as a DBA: Your First Month on the Job – Things to think about, working triage on the job, lessons learned. Find out about how to dig through the noise and figure out where you should start. > Watch the Show […]
Let’s open up the multi-row discussion again
(Willie Favero) For some reason it seems like the only time I write about multi-row processing delivered by DB2 for z/OS Version 8 lately is when I’m in a hotel. This time though I’m not stranded. This time I’m in Poughkeepsie on purpose…
Building Dynamic Websites Using XML Files
(Amal ElHosseiny) In this article I will present how to build websites with dynamic content. Content is saved in one XML file so you will not think about database hosting problems.
The Oracle 11g UNPIVOT operator – turning columns into rows
(Lucas Jellema) The PIVOT operation is one frequently discussed when talking about more advanced SQL Queries. Pivoting is the process of switching rows and columns, and is for example an advanced feature in Excel. Before Oracle 11g, there were several approaches to pivoting, that were not work-aroun
Mini-Tip #14 – View AnyData
(Lewis Cunningham) When you work with Streams and LCRs, you often have a need to view AnyData data. AnyData is also useful when you need truly dynamic singatures on your stored procedures. I’ll do some more on AnyData in the future but for now, here’s a way to view AnyData as a string.