(Richard Carr) When developing console applications, it is common to need to clear the screen before requesting new input or displaying new content. This is simple to achieve with a single method call.
Author: SSWUG Research
SQL SERVER – Identify Oldest Active Transaction with DBCC OPENTRAN
(Pinal Dave) I recently received a question on my Facebook page-
Generating Test Data in TSQL
(Hugo Kornelis) To test SQL, you need test data. There are usually many reasons why you can’t use production data. Although it is usually enough to use a utility to generate test data, sometimes your requirements will compel you to resort to code to supplement this.
Transactions: Who, What and Where
(Kenneth Fisher) Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I looked into sys.dm_exec_requests I could see all of the blocked requests, but could not find a request with a session_id matching the blocking_session_id.
Getting Starting with Change Data Capture (CDC) in SQL Server – Part 1
(Arshad Ali) There are two approaches to loadrefresh data from a source system to a data warehouse; the first approach is to load the full set of data every time and the second approach is to load the full set of data for the first time and then subsequently load only the changed data set as incre
7 Things You Should Know About the Geolocation API
(Bipin Joshi) Many websites don’t need to know anything about the geographical location of their visitors. In certain cases, however, this knowledge can be useful and can be used to enhance the user experience. This knowledge can also be used to integrate special features into your application.
DB2 for z/OS: Answering Some Questions About Adding and Dropping Table Columns
(Robert Catterall) From the very beginning, you’ve been able to add a column to an existing DB2 for z/OS table by way of the SQL statement ALTER TABLE with the ADD COLUMN option. In fact, relative ease of logical database design modification had a lot to do with DB2 becoming a very widely used DBMS.
ORA-01792
(Andrew Reid) I tested this example in Oracle 11.2. First I created a table with 1 column called COL1:
ASP.NET MVC Custom Membership Password Hashing based on SALT key using SHA-3 Algorithm
ASP.NET membership is designed to enable you to easily use a number of different membership providers for your ASP.NET applications. You can use the supplied membership providers that are included with the .NET Framework, or you can implement your own providers.
Activities vs. Requests
(Ember Crooks) This started as a conversation with a couple of DBA friends when we were playing with MONREPORT.DBSUMMARY. That’s a pretty nifty way to get a quick look at a number of performance parameters, AND to limit the time period covered by the report.