-
Do you think we have enough SQL Server experts? Article from Brain indicate there are shortage in SQL Server experts. “ There are certainly many world-class SQL Server experts, and there have been for quite some time. I suppose it’s more of a matter if there are enough available to satisfy demand. One...
-
Many programming languages like VB6 support IIF function which is used to return a value based on a particular expression/condition. In SQL Server the equivalent is to make use of CASE Expression, which is used to evaluate many conditions and return a single value. The following examples will give you...
-
We are about to start the logic testing of TSQL Challenge 29 . We have created a sandbox for the tricky testing and you can find it here . Please take a look at the tricky data and expected results and let us know if you find anything incorrect. We will start the tricky testing by tomorrow.
-
Database project is very good tool for supporting Agile development. More benefits of using this project are listed here and here . When we create a new database using SSMS, by default Page Verify Option for database is set to CHECKSUM, which is a recommended option and it helps detecting corruption...
-
We are about to start the logic testing of TSQL Challenge 28 . We have created a sandbox for the tricky testing and you can find it here . Please take a look at the tricky data and expected results and let us know if you find anything incorrect. We will start the tricky testing by tomorrow.
-
This post tries to explain the behavior of differential backups on a FILESTREAM enabled database. A number of times, I see questions looking for a confirmation whether Differential Backups will correctly backup the NTFS (FILESTREAM) files and restore them correctly when a differential backup is restored...
-
For various reasons you may need to audit some activities on certain tables.Usually you can use triggers for this.Sometimes you may want to know the system from which data are added or the user who added data.In these cases, you can use two functions host_name() and user_name() Host_name() This function...
Posted to
Madhivanan's TSQL Blog
by
Madhivanan
on
08-04-2010
Filed under:
Filed under: t-sql, sql_server, sqlserver, tsql, BRH, #TSQL, auditing, user_name(), host_name(), #DBA, dba
-
This post intends to help TSQL developers get started with PIVOT/CROSS TAB queries. Most business applications will need some sort of PIVOT queries and I am sure many of you must have come across pivoting requirements several times in the past. Let us say for example we need a result set as following...
-
I have already written several post about Linq its a great ORM that we can use in various way. The purpose of this post to demonstrate How we can bind custom entity to stored procedure result with use of Linq-To-SQL. Let’s go through it and you will realize that how easy it will be to bind a Custom...
-
This post shows a quick and dirty way of loading a huge file into the FILESTREAM column of a SQL Server 2008 database instance. Note that this is an unsupported method which is not recommended on a production server. The correct way of loading BLOB data into a FILESTREAM column The right way of loading...
-
If you want to restore a database from backup (.bak) into a new database. Then I recommend don’t do it from SSMS use query analyzer in master database. Couple of days before I got an error while restoring my database from SSMS whenever I select the .bak file it shows me Error:’The backup set holds a...
-
Recently I have been working on a article for my blog for that I just tried to add a database file on my solution with visual studio and I have received following error. An error has occurred while establishing a connection to the server. (provider: Named Pipes Provider, error: 40 – Could not open a...
-
Before some days i was installing SQL Server 2008 R2 Express edition on my machine and every time when it runs checks for required settings it was failing giving error reboot required. I have rebooted my machine several time and result was same. After that i have search it on internet and found that...
-
Sometimes, it is necessary for a database administrator to move database transaction log files. For example, the host partition can run out space or the subsystem disk architecture can change. Move files on a normal situation is pretty straightforward but with log-shipping the operation can be slighty...
-
We are about to start the logic testing of TSQL Challenge 27 . We have created a sandbox for the tricky testing and you can find it here . Please take a look at the tricky data and expected results and let us know if you find anything incorrect. We will start the tricky testing by tomorrow.