(Ben Nadel) Unfortunately, people seem to treat the $timeout() function in AngularJS as a set-it and forget-it type of function. But, forgetting about your $timeout callback can have negative consequences, all the way from code that fails silently to code that raises an exception to code that makes
Author: SSWUG Research
How to Store Text in Strings in Python
(Katie Cunningham) When Python wants to store text in a variable, it creates a variable called a string. A string’s sole purpose is to hold text for the program. It can hold anything—from nothing at all (“) to enough to fill up all the memory on your computer.
Creating a Business Intelligence Dashboard with R and ASP.NET MVC: Part 3
(Sergei Dumnov) In the first two parts of this series of articles, I set the groundwork for a solution that used ASP.NET MVC to create a simple site for a fictitious company called NorthWind Traders with a SQL Server database and which used R for the analytics and visualization.
WPF Base Classes – Decorator
(Richard Carr) The thirty-fourth part of the Windows Presentation Foundation Fundamentals tutorial describes the Decorator class. This is another base class for WPF controls, including two of the layout controls seen earlier in the tutorial.
Reusing A Power Query Connection
(Chris Webb) One of the things I like least about Power Query at the moment is the lack of control over where the results of your queries end up in Excel. For example, if you create a new query and load it onto a worksheet, your table always ends up in the top left hand corner of a worksheet.
SQLT Emergency Plan Change
(Bobby Durrett) I’m on call this week so I didn’t plan to do any blog posting but I had an interesting performance issue this morning that I thought would be helpful to document. This is somewhat redundant to earlier posts but maybe another real example would be helpful to others (and myself as I t
SQL Developer: BLOBs and the External Editor
(Jeff Smith) We already know how easy it is to view images and plain text with the BLOB editor, yes?
Exadata: what kind of IO requests has a cell been receiving?
(Frits Hoogland) When you are administering an Exadata or more Exadata’s, you probably have multiple databases running on different database or “computing” nodes. In order to understand what kind of IO you are doing, you can look inside the statistics of your database, and look in the data dictionar
Maximizing Throughput with TVP
(Steve Howard) This technical note looks at considerations of whether to use the SqlBulkCopy, or Table Valued Parameters (TVPs) in a customer scenario encountered as part of a CAT engagement.
Change in SQL 2012 SSMS grid output behavior
(Kenneth Fisher) It’s one of those things that always aggravated me but not really enough to complain about. When you run a query to grid in SSMS then copy and paste the value to a query window it stripped the carriage return/line feed.