It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes to ask vital questions about SQL Server primary keys and foreign keys. Fear not, here are 13 questions you were too shy to ask, answered.
2014-10-14
9,933 reads
Trying to determine if you have pressure in your buffer allocations can be difficult. This metric reliably indicates if you have a buffer problem using the memory dump from DBCC MEMORYSTATUS() and comparing Target Committed to the Current Committed allocations. If you hit negative numbers you are looking at a buffer issue.
2014-10-14
6,901 reads
As working hours in tech trend upwards, we look at some ways to make life easier.
2014-10-13
129 reads
Here is a step by step procedure to create a linked server to MySQL from SQL Server.
2014-10-13
3,529 reads
Join the world's largest gathering of SQL Server and BI professionals in Seattle on November 4-7. PASS Summit is your conference – planned by and for the SQL Server community. Red Gate will be exhibiting, so drop by their booth and say hello. Register while space is available.
2014-10-13
8,510 reads
Greg Larsen shows you a number of different ways to use the UPDATE statement to modify the data in your SQL Server tables.
2014-10-13
10,280 reads
With the Konesans File Watcher Task for SSIS we can import files as soon as they arrive.
2014-10-10 (first published: 2012-08-13)
19,122 reads
With the release of SQL Server 2014 there came a lot of new features, including “In-Memory OLTP”. One would assume that storing a table in memory would most definitely be faster than using the conventional disk-based table storage engine. But just how much faster is it?
2014-10-10
8,756 reads
2014-10-09
30,291 reads
The public perception is that, when something is deleted, it no longer exists. Often that's not really the case; the data you serve up to the cloud can be stored out there indefinitely, no matter how hard to try to delete it. Rob Sheldon investigates, and finds the cloud a worryingly public place.
2014-10-09
8,992 reads
I’ve been thinking a lot lately about what it actually takes to make an...
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Comments posted to this topic are about the item Finish the quote
Comments posted to this topic are about the item Everything I Needed to Know...
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers