sqlconcept.com
BI « sqlconcept.com
http://sqlconcept.com/category/bi
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. Creating and populating Date dimension in a DW for use in SSAS. Here is a script I found on SQLDusty’s blog on how to populate a Date dimension. I am re-posting this script here so I can have access to it at any time. Props to Dustin! View Code TSQL–Make sure you set the Start and End Date below on row 58 and 59. 8211;Create the tables.
sqlconcept.com
Baselining « sqlconcept.com
http://sqlconcept.com/category/baselining
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. SQL Server 2012 Full-Text search and XML Search - the Wiki project. Finally, here are some results from the Wiki project. After a few days of development, here is the accounting for the wiki project:. Desktop PC with 8Gb RAM, single home use HDD. SQL Server 2012, using XML and Full-Text search. The total amount of data to be imported: 39.2 GB. The rea...
sqlconcept.com
Becoming a sponsor « sqlconcept.com
http://sqlconcept.com/becoming-a-sponsor
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. So far I have been keeping this site away from advertisement at any rate. And yes, the rate is high. I pay out of my pocket for:. My family and friends’ free time. However, I am open to suggestions. If you think that this site should get colored by advertisement – feel free to drop me a line. And make me an offer. Who knows, I might go for it.
sqlconcept.com
My Articles « sqlconcept.com
http://sqlconcept.com/my-articles
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. HDDs, SSDs and Database Considerations. By Feodor Georgiev, 09 January 2013. In this article Feodor clears up a few myths about storage, explains the difference in how HDDs and SSDs work and looks into the considerations every DBA should have in mind when choosing / working with SSDs. Read more…. How come the Hourglass? As the volume of data increases...
sqlconcept.com
Business Intelligence « sqlconcept.com
http://sqlconcept.com/category/business-intelligence
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. Creating and populating Date dimension in a DW for use in SSAS. Here is a script I found on SQLDusty’s blog on how to populate a Date dimension. I am re-posting this script here so I can have access to it at any time. Props to Dustin! View Code TSQL–Make sure you set the Start and End Date below on row 58 and 59. 8211;Create the tables.
sqlconcept.com
. . . Products . . . « sqlconcept.com
http://sqlconcept.com/products
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. If you like this site, you can buy me a cup of coffee by donating any amount (in USD). Paul Turley's blog.
sqlconcept.com
. . . . . Tools . . . . . « sqlconcept.com
http://sqlconcept.com/tools
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. On this page you will find the tools developed by SQLConcept. So far the tools are distributed for free. The first tools is the DefaultTraceAudit. Which is currently owned by SQLService. For information and F.A.Q.’s about the DefaultTraceAudit. For screenshots of the DefaultTraceAudit. For downloads of the DefaultTraceAudit. Paul Turley's blog.
bveldhoen.wordpress.com
Map Request to Response in BizTalk Server | Bram Veldhoen's Weblog
https://bveldhoen.wordpress.com/2011/01/12/map-request-to-response-in-biztalk-server
Bram Veldhoen's Weblog. Sela Developer Practice samples. Asynchronous transactions and propagation in WCF →. Map Request to Response in BizTalk Server. Consider the following scenario:. You need to receive a message into BizTalk Server, and send an acknowledgement back to the sender (probably using a Request-Response port). The response is trivial, it’s similar to a void response in WCF, or containing only information that can be obtained from the request message (such as an ID or something). Pipeline co...
sqlconcept.com
Data Science « sqlconcept.com
http://sqlconcept.com/category/data-science
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. Statistical Learning and visualization courses. There are two great resources I found recently and I am going though them as we speak. The first one is a course on Statistical Learning, which can be accessed here. The second one is a course on visualization by using the ggvis package in R, which can be found here. And here is where we draw the line.
sqlconcept.com
SQL Latency Meter « sqlconcept.com
http://sqlconcept.com/tools/sql-latency-meter
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. If you like this site, you can buy me a cup of coffee by donating any amount (in USD). Paul Turley's blog.
SOCIAL ENGAGEMENT