This webinar, presented by Noemi Moreno, BI Developer at Red Gate Software, will consist of a 30 minute software demonstration followed by Q&A. You will see SQL Developer tools in action, and how they can simplify and enhance your Business Intelligence applications. This takes place on Apr 19, 2011 from 4pm-5pm GMT.
We live in a great age of data and Steve Jones thinks it's a great time to be a data professional, especially if you work on your data presentation skills.
Do we, event organizers, tool vendors, concerned SQL citizens, as a community, do enough to reach people who don't know about the training available to them?
Your job is to write a query that identifies the longest matching country/area code from each phone number based on the information stored in an area-code reference table.
Whenever rows or columns are deleted from a table, SQL Server reuses space to accommodate new data. However, this is not the case when a variable length column is deleted. The space used by this type of column is not reclaimed automatically. Variable length columns can be of data types varchar, nvarchar, varchar(max), nvarchar(max), varbinary, varbinary(max), text, ntext, image, sql_variant, and xml. In this tip, I have tried to put forth a solution to reclaim this space and this should work for SQL 2005 and later versions.
The SQL-92 standard introduced the LEFT Outer Join operation which offers a powerful alternative to standard relational processing to perform full hierarchical processing naturally and inherently. This enables SQL to transparently integrate relational data with XML, IMS and other forms of legacy hierarchical data. This can also allow the so far overlooked integration of IMS and legacy data with the Internet and XML, and visa versa.
Today we have a guest editorial from Andy Warren that talks about what DBAs might need to know in the future.
You are a database developer looking for a common approach for handling read and write access to binary files. You may be a DBA wanting to read various information from binary files and collect it into tables. The code sample presented in this tip will get you started with binary file content handling in SQL Server.
Platform as a service, a new way of looking at applications. It's analogous to SAAS and IAAS, which can improve the efficiency of the software purchase or the hardware acquisition process. Steve Jones notes that this is something he'd like to see for database platforms.
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
The DBA life is fraught with pain. Those battles that we endure are mostly...
hi, im not a dba. For a couple of years our dev sql server...
Hello, I would like to ask whether it is technically possible to redirect a...
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Can I set Accelerated Database Recovery on tempdb?
See possible answers