The programmable world. It's an interesting concept, but not one in which we have extremely detailed specifications and strongly bound software systems that must be built to interact with each other. I think many of us have assumed that's how we would enable the further computerization of our physical world. As an example, we'd have cars that communicated with the road, with other cars, with semi-central authority(ies) that might be managing our interactions, all of the infrastructure pre-built.
However that isn't necessarily what will happen. In this O'Reilly piece, the author notes cheap sensors can read the color of lights in the same way that humans or my Lego Mindstorm can detect color. Traffic sensors need not communicate with cars; these sensors could instead just identify cars and count them, measuring their speed and adjusting traffic lights based on actual conditions. Imagine the future when more and more sensors gather their own data and make decisions.
In a sense, this is how the Google self-driving car works. Rather than depend on infrastructure and external programming, the car gathers its own data and adjusts its behavior depending on the interpretation of the data. Whether or not you like the idea of self-driving cars (I do), the idea of an autonomous device acting based on programming and a large amount of data is a fascinating move forward in computing.
I think this shows that data gathering, processing, and analysis will become a more important part of our future computing worlds. Some of this data will be transient and discarded, but lots will be stored. We'll use data to ineract with the real world immediately, but we will also perform analysis later and reprogram our devices to operate better in the future. That means there will be new, and more, opportunities for those of us working with data.
This metric measures the percentage of free space for transaction log files (LDF files). You’ll find this useful if your SQL Server has limited capacity, so you need to maximize existing disk space utilization by minimizing unused space. It will also alert you if the amount of free space drops below the specified thresholds. More »
Scott Murray has used the Top and Bottom T-SQL functions in SQL Server and wonders, do the same functions exist in the SQL Server Analysis Services (SSAS) or MDX? If so, how do they work? Can you provide some examples? Check out this tip to learn more. More »
SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution. Get your copy from Amazon today.
Yesterday's Question of the Day
(by Samith C):
What will be the result of this batch?
declare @i int
set @i = 2
if @i = 1
declare @j int
set @j = 1
Answer: 2 1
Explanation: In this batch, the ELSE statement is executed, which prints "2". The variable is reset and the new value ("1") printed. The Declaration inside the "then" portion of the IF statement is ignored.
A friend of mine asked me to help him on a project he had at work. Basically he was asked to create a simple report such as: GID, Week4,Week3,Week2,Week1,Turnover based on a table that stores the sales data something like this: GID, SaleDate, ItemQty, ItemPrice. Going back to the report:
- GID- should be unique- consider it a product id if you want;
- Week1- sum of the sales that have been made 3 weeks ago (meaning starting from Monday until Sunday)
- Week2- same as Week4 but for the week following Week4-> 2 weeks ago basically
- Week3-same but 1 week ago Monday to Sunday
- Week4- sum of all the sales made by this Monday until right now (or Sunday considering the possibility of having sales recorded in the future)
- Turnover- it's the avg of the week columns, but only for those whose value <>0. eg:
Turnover=(2000+800+900)/3 (not 4!) = 1233
The application my friend tries to configure can be used to design reports, but these reports can use as data sources ONLY views or tables. Thus the challenge! :D ...Challenge Accepted!
1. Each week should be filtered from Monday to Sunday as per the current date the report is ran at. Eg: If the report is ran today (20130906) this is how the sales amount should be filtered based on the sale date:
Splitting row into 2 rows
I have a table witht he following structure.
EmpNo DutyId StartDate EndDate
101 01 2013-08-31 22:00:00 2013-09-01 06:00:00
The employee duty spanned...
SQL Alerts and WMI
- I'm trying to create an alert disk % free space left using:
SELECT * from __InstanceModificationEvent
TargetInstance ISA 'Win32_LogicalDisk'
multi-valued report parameter weirdness
- SSRS 2012, SQL 2012
I watched Brian Knight's video on filtering a report using a multi-valued parameter (here:[url]http://www.sqlservercentral.com/articles/Video/64369/[/url]), and after seemingly...
I've a table that has a trigger for insert that executes the flowing statement:
UPDATE ArtigoArmazem SET QtReservada = 0 FROM INSERTED...
Msg 4862, Level 16, State 1, Line 1
- with reference to OPENROWSET (TRANSACT-SQL) http://technet.microsoft.com/en-us/library/ms190312.aspx
1 Data Item 1
2 Data Item 2
3 Data Item 3
no-xml format file
1 SQLCHAR 0...
Problem with Cursor in trigger
- Hi all,
I have the following trigger after AvailPhysical field is updated.
Although I have written that table field ITEMID must start...
Merge with more then one insert statement
- Table1 :
MERGE Table1 t1
USING table2 t2
ON t1.id = t2.id
WHEN NOT MATCHED THEN
as like this i have 16 names...
I did a check in my table and I found these duplicates:
Key Month Usage
45 Sept 464
45 Sept 471
28 Sept 762
trim column values
- Hi Professionals
I have a varchar column in my table with pricing information in it that has up to 4 decimal...
Cannot figure out my update correctly
- Hi professionals
I have a table like so
my employer wants me to update the table column invoiceno and concatonate the invoiceno...
Concat column values
- I have following table
I want the output in following format
Why is my logon trigger blocking logons?
- I've created the following trigger to track logons:
Create database AuditDB
CREATE TABLE [dbo].[ServerLogonHistory](
[SystemUser] [varchar](512) NULL,
Move row value into column
- I would like to pull a query with each student each day an attendance record.
Our database setup an AM and...
Problem with update syntax
- Hi all -
I am preparing create tables with test data, but I thought this might be so simple and generic...
Extract string between to characters
- I've a string in following format:
First I've to extract the strings between < and >
like: 1|458|test|q 2|789|test2|s 5|567|test3|p
after that I've...
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.