The idea of philanthropy is giving back to the world, doing some good because of the success you have had or gifts you've received. Imagine that we thought not about giving our time or money, but our data instead.
I read this piece on data philanthropy that talks about the possibilities of improvement in the public service and applications we have from philanthropy. However the piece talks not about more resources, but more data, coming from the private sector. Data from cell phone companies, transportation companies, and more that can help us better understand how the world is functioning, how it interacts, and how that might affect the public goods and services.
I like the idea of Open Data that exposes more information from our government to the private sector for incorporation in applications, for additional analysis by private entities, and for the transparency that our government is acting in our collective best interests. However you believe government ought to function, without more data about how it does function and uses its resources, we can't know about which things we should seek to influence.
However I think we have a tremendous amount of data being collected by companies that can help government run more efficiently, and making the corporate decision to share that data can help improve the communities in which a company does business. We know that much of our data has information, but we can't take advantage of all the information, and may not want to. Perhaps donating some of this data to the collective good is a way to adhere to, and reinforce, the social responsibility many companies include in their annual reports.
Toda's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com. You can also follow Steve Jones on Twitter to find links and database related items and announcements.
Every DBA must understand SQL Server concurrency and how to troubleshoot any issues. Kalen Delaney's eBook explains all - download it today.
12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.
SQL in the City – Free SQL Server Training the Red Gate way
Red Gate is hosting free seminars and events in the US this summer and fall. Learn about best practices for SQL Server database development and administration from top SQL Server MVPs. Find out more and register
Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your time. On October 15th come see why BI professionals around the world think Biml is the future of data integration and BI. More »
SQL Saturday is coming to Sacramento on July 27, 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday also features a paid-for full day pre-con session with Kalen Delaney More »
This article looks at SQL Server locking and transaction isolation levels, how to set the transaction isolation level, and how some isolation levels use locking, while others use row versioning. It also explains what type of locks data update requires. More »
Question of the Day
Today's Question (by Carlo Romagnano):
What is the result of this batch? (select two)
return select 2
return (select 5)
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth
1 point in this category: T-SQL.
Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks. Get your copy from Amazon today.
By Jesse Roberge - YeshuaAgapao@Yahoo.com
The SpaceLog builder
Records database space usage and buffer cache usage statistics into the SpaceLog_* tables.
Keeps a record of database and table growth for reporting of growth trends.
Stats include Reserved, Used, Data, and buffer cache page counts for row, lob (VarChar-Max, text etc), and overflow data (data rows with varchar columns going over 8000 bytes).
Stats also include some computed columns such as BTree (Used-Data), unused (Reserved-Used), and sums of row+lob+overflow for each of reserved, used, data, and buffer.
The database, dataspace, schema, and table levels give stats for the nonclustered index and the table itself (heap or clustered index).
Designed to run and record to a central 'admin' database location.
Requires VIEW_SERVER_STATE due to the querying of sys.dm_os_buffer_descriptors for buffer cache usage stats. DB-owner does not have this permission.
Sysadmin does have this permission. VIEW_SERVER_STATE can be granted as a separate permission to some or all dbo users.
Required Input Parameters
Optional Input Parameters
@GatherDatabaseName sysname='', Name of the database to gather the space usage stats from. If omitted, the name will be looked up from the ID. If both ID and name are omitted, the ID/Name of the current database is used.
@GatherDatabaseID int=0, ID of the database to gather the space usage stats from. If omitted, the ID will be looked up from the name. If both ID and name are provided, the ID takes precedence.
@RecordDatabaseName sysname='', Name of the database to record the space usage stats to. If omitted, the name will be looked up from the ID. If both ID and name are omitted, the ID/Name of the current database is used.
@RecordDatabaseID int=0, ID of the database to record the space usage stats to. If omitted, the ID will be looked up from the name. If both ID and name are provided, the ID takes precedence.
@RecordSchemaName sysname='', Name of the schema to record the space usage stats to. If omitted, the name will be looked up from the ID. If both ID and name are omitted, the 'dbo' (ID=1) schema is used.
@RecordSchemaID int=0, ID of the schema to record the space usage stats to. If omitted, the ID will be looked up from the name. If both ID and name are provided, the ID takes precedence.
@UpdateUsage tinyint=0 Default and recommended to be off. Use only if you must have the most accurate and up to date numbers. Will run DBCC UpdateUsage to scan every table in the database to re-count all allocations and rows, which can hog disk IO for serveral hours.
need solution and feedback to the below question!!
- here is the sample data .
create table empp(eno int,ename varchar(25),dept varchar(3))
insert into empp values(101,'raghava','hr')
insert into empp values(102,'krish','hr')
insert into empp values(103,'venkat','fin')
FORXML not retrieving complete xml
I am having the below XML
<marketDataSeries xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://pricesandcurves.ist.bp.com/xsd/CSL/IST/marketData/v1" xsi:schemaLocation="http://pricesandcurves.ist.bp.com/xsd/CSL/IST/marketData/v1 marketData.xsd" seriesID="urn:pc:FO.E.34639">
DATABASE BACK UP PROBLEM
- Correct me ,, if i am posting my problem in a wrong forum.
Here i in my company i am using full...
Tempdb files - Load test
- How to arrive at the number of tempdb files needed for a SQL 2008 2 processor server. Everyone mentions about...
quick edit data
- I recently found a quick way to do some data editing for a table with filter added.
That is from design...
Truncating data on a remote Server
I am trying to truncate data from one server to the other (remote server)
[u][b]it works from query analyzer like this:[/b][/u]
Performance issue on DB
We have a sql 2005 prod server,where one of the DB became very slow past 5 days.
i have observer that...
Handling error message
- Hi, while writing script I have to check that whether input value is correct or not and then display the...
The average bytes/read is between 64k and 128k and the average bytes/write is between 32k and 64k.
What is the best,...
SQL Disk Error
- Dear Gurus,
I am getting attached error of disk when installing SECOND INSTANCE of SQL 2008 R2 please help .
SSIS in cluster
I have two nodes nodeA and nodeB on a sql server on a fail over clustered environment. Each of these...
Prev and Next Row Without RowNumber
- Hello All,
Can anyone help me with this one.
here is the table sample.
CREATE TABLE [dbo].[Invoice_t](
[Cost_Center_code] [int] NOT NULL,
[Payment_code] [int] NOT NULL,
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.