Database Checkups
It's important that you are watching your databases' health to be sure that you can make changes, as well as rollback patches when issues occur.
I am no Asimov
Rodney Landrum on finding the inspiration you need, somehow and from somewhere, to get yourself out of a tight corner.
Removing SQL Server Management Data Warehouse (Data Collector)
Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.
Azure Diagnostics for Virtual Machines
Hosting a scalable application in Azure seems ideal, but what happens when things go wrong? Azure Cloud Services provide extensive diagnostics, and this feature has now been extended to Azure web sites and Azure Virtual Machines. You need to set up diagnostics on the VM, but once this is done, all your logs, traces and performance counters can be collected from many VMs in one place for easy management.
#SQLPASS Election Interview with James Rowland-Jones
An interview with James Rowland-Jones in advance of the PASS election.
Integrating Big Data into the Enterprise Data Warehouse
Big Data implementations are more than just lots of data. Of equal importance is the analytics software used to query the data. Analyzing business data using advanced analytics is common, especially in companies that already have an enterprise data warehouse. It is therefore only natural that your big data application must be integrated with the existing warehouse.
SQL Saturday #318 - Orlando
This is Orlando's 8th SQLSaturday and this year will be better than ever with more than 50 different speakers giving over 50 presentations - all for FREE. Sept 27, 2014.
Monitoring Longest Running Transaction using SQL Server Agent Alerts
Step by Step guide to setup SQL Server Agent Alert for the proactive monitoring of Monitoring of Longest Running Transactions.
Free PDF Booklet: 119 SQL Code Smells
Once you've done a number of SQL code-reviews, you'll be able to identify signs in the code that indicate all might not be well. These 'code smells' are coding styles that, while not bugs, suggest design problems with the code. In this PDF, Phil Factor's put together 119 of those code smells so you can see what to avoid and why.
SQL Saturday #333 - St. Louis, MO
SQL Saturday is coming to the St. Louis University Campus on Oct 11, 2014. SQL Saturday offers a full day of free SQL Server training and networking, some of the speakers at this event include Kathi Kellenberger, Stuart Ainsworth, and Abhishek Srivastava. If you're thinking of attending this event, please register while space is available.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
Cara buka blokir bank jago yang terkunci
dapat dilakukan dengan menghubungi layanan pelanggan Tanya Jago di 1500 746, WhatsApp resmi (+62813_2244_602...
Cara membuka blokir bank jago yang terkunci
Anda dapat menghubungi layanan Tanya Jago melalui WhatsApp resmi (08132244602 / 08217142959), atau call...
Cara membuka blokir bank jago
Cara membuka blokir Bank Jago dapat dilakukan dengan menghubungi Tanya Jago via WhatsApp resmi...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers