(Steve Felts) Every Oracle database connection runs in the context of a database process called a session. There is a v$session view that contains a lot of information about the database sessions that are active.. By default when you use the Oracle Thin Driver, the value v$session.program is set to
Other News
3 Areas to Verify When Experiencing DB2 Performance Degradation
(Dave Beulke) When you experience DB2 performance degradation, you’ll discover no one has changed anything (of course), or admits to changing anything. Luckily there are a wide variety of DB2 performance dependencies to check.
Examining the TokuDB MySQL storage engine file structure
(Peter Zaitsev) As we know different storage engines in MySQL have different file structures. Every table in MySQL 5.6 must have a .frm file in the database directory matching the table name. But where the rest of the data resides depends on the storage engine.
Dynamic Css Menu Creation in Asp.Net Using C#.Net
(Pranav Singh) Dynamic menu creation is one of the most important parts if a website development. So today I will show you how you can create dynamic css menu using in asp.net using CSS/CSS3. This will cover label 2 menu.
Using Environment Variables in Visual Studio 2013 and TFS 2013
(Gouri Sohoni) In this article, we will view various ways using which environmental variables can be accessed with Build Definition. We will be using Visual Studio 2013 and Team Foundation Server 2013 Build Service for that.
WPF: How to change the Source of an Image Element at Runtime
(Ged Mead) This is one of those things I know how to do, but keep on forgetting! So, for the record, here’s the syntax that lets you assign a new image file to a WPF Image at run time.
Scripting Objects with PowerShell
(Derik Hammer) The ability to script out the definitions of objects is valuable to any DBA. Most of us are intimately familiar with SQL Server Management Studio’s capabilities in this regard. Simply right-click on your object and navigate to the “Script object as” sub-menu.
Export a SSMS Query Result Set to CSV
(WaterOx) Once you have a query that is returning the data you like in SSMS you have a few options to move the result set into a format that you can use in other tools.
SQL SERVER – Convert Seconds to Hour : Minute : Seconds Format
(Pinal Dave) Here is another question I received via email.
What does it mean to be a SQL Server DBA
(Jeremy Kadlec) I am aspiring to become a SQL Server DBA. I have seen numerous sets of information related to SQL Server tests, conferences, user groups, your tips and more, but what does it really mean to be a SQL Server DBA? What should I really aspire to become as a SQL Server DBA?