Forgot password? Sign Up

Blogs about: Sql

Featured Blog

How to back up a User Profile Service application using SQL Server in SharePoint 2010 ?

Pratik Vyas wrote just now: Open SQL Server Management Studio Connect to the database server. Expand Databases. Right-click the … more →

Tags: SharePoint 2007, backup, Database, Microsoft SQL Server, Mouse (computing), Server, SQL Server Management Studio, user profile

Event ID: 10036 A database error occurred

Pratik Vyas wrote 6 minutes ago: Issue: Event Type: Error Event Source: Office Server Search Event Category: Gatherer Event ID: 10036 … more →

Tags: SharePoint 2007, A database error occurred, Database, Event ID 10036, event viewer, Microsoft, Microsoft SharePoint, Microsoft SQL Server, SharePoint

Quick Demo to get MetaData & Data in XML

mattdee wrote 5 hours ago: Here’s a quick demo to show off DBMS_METADATA and DBMS_XMLGEN APIs in the Oracle Database … more →

Tags: Database, Oracle, Bash, xml, dbms_metadata, dbms_xmlgen, Metadata

Oracle Performance coding standards

Abhijit Ray wrote 5 hours ago: View this document on Scribd … more →

Tags: Training Docs, Concurrent Manager Jobs, Data Modeling, Discoverer, Forms, Java, PL/SQL, Pro*C, Reports

DateTime to a preferred (15 minutes) interval

Clint Huijbers wrote 8 hours ago: Seriously, this piece is another great addition to your cookbook! Before this…make a guess … more →

Tags: SQL Server 2008 R2, SQL Server 2008, T-SQL, SQL Server 2012, datetime, Interval

Quick Tip - Resolving Slow load times on Search Content Sources Page

red1s wrote 8 hours ago: http://www.facebook.com/widgets/like.php?href=https://red1s.wordpress.com/2012/05/29/quick-tip-resol … more →

Tags: Search, Sharepoint 2010

VMware vCenter SQL Express database reached maximum database size

bartvdw wrote 10 hours ago: Recently had a customer who’s SQL Express database for VMware vCenter reached the maximum data … more →

Tags: VMware

Entity Framework 5.0 (4.0) Performance Improvements–Part 6

ilivedigitally wrote 12 hours ago: This article is a part of a series. Please read the Part 1 – 5 if you have not done so. Entity Frame … more →

Tags: Entity Framework (EF), CompiledQuery, LINQ, ObjectQuery

Performing LEFT OUTER JOINs with LINQ

ip3lee wrote 13 hours ago: Performing a LEFT OUTER JOIN with LINQ is pretty simple and straightforward so why a post? Well I … more →

Tags: .NET, LINQ

How to Import data from Excel to MS SQL

mikkarin wrote 16 hours ago: select * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\test.xls;Extended Properties … more →

Tags: Excel, excel 2

Foreign Key Query

Julius Nyotowijoyo wrote 19 hours ago: Here is a cool Foreign Key Query I got from http://michaeljswart.com/2012/05/the-view-of-foreign-key … more →

Tags: Programming

Sample using SQL Command Line

tootlesoft wrote 20 hours ago: “C:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqlcmd.exe” -S .\SQLEXPRESS -i C:\ … more →

Backup All Data Base SQL Server

tootlesoft wrote 20 hours ago: DECLARE @name VARCHAR(50) — database name DECLARE @path VARCHAR(256) — path for backup f … more →

BISQL # 98 - Introduction of Private Cloud with SQL Server and Hyper-V, Resource Link

Vishal Pawar wrote 22 hours ago: Hi Friends , Today i thought of writing something on cloud w.r.t SQL Server, Now day moving on cloud … more →

Tags: Link

Security Guide for SAP on SQL Server 2012 - Whitepaper Released

Vishal Pawar wrote 22 hours ago: Hi Friends, Following white paper will help you fro SAP on SQL Server 2012 – Security recently … more →

Tags: Link

BISQL #97 - Laymen to SQL Developer # 9 - Assignment #2 - Relational Model, Schema, Attribute, Database, Key & Relational Query

Vishal Pawar wrote 22 hours ago: Hi Folks , It had been months, I was not able to write a single post on Laymen to SQL Developer seri … more →

Tags: query, Link, ZeroToBasic

Developer Training - Employee Morals and Ethics - Part 24 comments

pinaldave wrote 23 hours ago: Developer Training - Importance and Significance - Part 1 Developer Training – Employee Morals … more →

Tags: Developer Training, postaday, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T-SQL, technology

Oracle CASE statement

sqlandplsql wrote 1 day ago: CASE is an extended version of decode in Oracle. ( Read about decode here - Oracle DECODE function ) … more →

Tags: PL/SQL, Oracle CASE statement

Determining NLS_DATE_FORMAT

Mark Hoxey wrote 1 day ago: As a short follow-up to a previous post regarding implicit date conversion and the NLS_DATE_FORMAT, … more →

Tags: Oracle


Have your say. Start a blog.

See our free features →

Related Tags
All →

Follow this tag via RSS