Display All Errors Fired in a Restore Procedure
Display all errors thrown within a catch block by a restore statement in a stored procedure using extended events
Try to focus on the positive
When we focus on negative things we get more negative. Be thankful for something positive.
On Comparing Tables in SQL Server
How do you compare two SQL tables? Every SQL Developer or DBA knows the answer, which is 'it depends'. It is not just the size of the table or the type of data in it but what you want to achieve. Phil Factor sets about to cover the basics and point out some snags and advantages to the various techniques.
SQL Monitor Custom Metric: Ad Hoc Queries Running Once
This metric measures the total number of ad hoc queries in the plan cache that have only run one time. The value is only accurate for the instant the query is run, and the value can change radically from one capture time to the next.
Anything Remotely Useful
Phi Factor on how to combine PowerShell Remoting with slick Windows tools such as SQLPSX, Boxstarter and Chocolatey, to automate the development process right through to delivery.
Getting the Most out of Statistics
Statistics keep track of our data and will tell SQL Server how to make the best optimization decisions. Knowing how they work can make understanding query and performance problems much easier!
Quick Guide to Installing SQL Server 2014
In this tip, we will demonstrate the installation of SQL Server 2014 on a notebook. While processing large amounts of data on a system like this might not be feasible, one can still learn how to configure and use the features of SQL Server 2014.
Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)
A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.
Motivating the Team
It's easy to get excited if you work at a startup, or a software company. But for corporate workers that toil in IT departments all around the world, how do you keep them motivated? Steve Jones has a few thoughts about simple things that make workers feel better about their jobs.
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCP Ngagel Jaya Selatan Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Ngagel Jaya Selatan No.25, Pucang Sewu, Kec. Gubeng, Surabaya, Jawa Timur 60283
BCA KCP Kertajaya Indah Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Manyar Kertoarjo No.95, Mojo, Kec. Gubeng, Surabaya, Jawa Timur 60285
Alamat kontak resmi BCA KCU BLITAR Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers