sqlblogs.wordpress.com
sqlblog | Just another WordPress.com weblogJust another WordPress.com weblog
http://sqlblogs.wordpress.com/
Just another WordPress.com weblog
http://sqlblogs.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Tuesday
LOAD TIME
0.6 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
9
SSL
EXTERNAL LINKS
0
SITE IP
192.0.78.12
LOAD TIME
0.625 sec
SCORE
6.2
sqlblog | Just another WordPress.com weblog | sqlblogs.wordpress.com Reviews
https://sqlblogs.wordpress.com
Just another WordPress.com weblog
sqlblogs.wordpress.com
About | sqlblog
https://sqlblogs.wordpress.com/about
I am a SQL Consultant living in Bay Area,CA with 10 years of experience in IT industry. Hobbies include travelling, cricket and movies. My education includes Bachelors degree in Computer Sceince and Engineering. 8211; Swami Kasiviswanathan. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out.
T-SQL Interview – Topics to focus On | sqlblog
https://sqlblogs.wordpress.com/2009/09/14/t-sql-interview-topics-to-focus-on
T-SQL Interview – Topics to focus On. September 14, 2009 at 9:07 pm. Below are some of the topics you might want to brush up before a t-sql interview. 6salary of 10 ppl maximum. Apart from this I would also recommend this. 3 Types of Locks and how to use them. 4 Profiler, Trace and DMVs. Entry filed under: Database development. Tags: SQL Interview - topics to cover for a T-SQL programmer. SQL Interview Questions -General. Leave a Reply Cancel reply. Enter your comment here. Address never made public).
Paging Using T-SQL | sqlblog
https://sqlblogs.wordpress.com/2009/09/18/paging-using-t-sql
September 18, 2009 at 7:27 pm. There are atleast two Common methods of paging in T-SQL:. 1 Row Number() and CTE. SQL 2005 features, not supported in SQL 2000). SELECT colA, colB, colC. ROW NUMBER() OVER(Order BY colA, colB) AS RowNumber. SELECT colA, colB, colC. WHERE RowNum BETWEEN (@PageNum – 1) * @PageSize 1. AND @PageNum * @PageSize. ORDER BY colA, colB. Note – We can also use a outer query instead of CTE. Common practice in SQL 2000). SELECT TOP n * FROM. ORDER BY columnname DESC. Get every new post...
Question from one of the developers | sqlblog
https://sqlblogs.wordpress.com/2009/09/30/question-from-one-of-the-developers
Question from one of the developers. September 30, 2009 at 10:08 pm. I got a mail from one of my friend to resolve some issues he is facing during development. Below is the mail content. Hi Swami, need some info from u on SQL Server … I am looking into some articles in google but just wanted to know whether u have worked on those. 1) How to set up dirty reading for a table in SQL Server? Is that a setting at the table level? 2) I have a requirement in SQL SERVER. Do the foll operations. My quick Answer i...
SQL Injection | sqlblog
https://sqlblogs.wordpress.com/2009/10/06/sql-injection
October 6, 2009 at 6:11 pm. There are thousands of site which are still vulnerable to SQL Injections. Let me try to explain how this happens. Say for example your company has a orderStatus search textbox in its web site which does the below simple function. 1 Users input a orderId. 2 the server takes the orderId. 3 queries the database. 4 and give the orderstatus. Your asp code will look like(I have used classic asp here but this can be in any server side scripting). Will look like this. Entry filed unde...
TOTAL PAGES IN THIS WEBSITE
9
SQL Server Blogs
Voices from the UK SQL Server Community. UK SQL Server User Group. UK SQL Server User Group was established in 1998; it facilities community via it's website and through physical meetings across the UK. SQL Server 2008 R2. SSIS - Integration Services. SQLBlogCasts is a free service to those folk who want SQL Server related blogs. It's there to support the online community especially in but not limited to the UK. The site is a partner of the UK SQL Server User Group.
sqlBlog
SqlBlog is all about keeping a track of all the tips, fundas and other notes which I came across in various forums, posts and my personal experiences. Sunday, April 28, 2013. SqlBlog will be up. Last few months have been very hectic due to reading,travelling and some personal commitments.Here after sql blog makes a commitment to atleast publish one post per week. Catch you there. Friday, August 27, 2010. SQL Deployment versus File System Deployment in SSIS. Best in File System. Monday, September 1, 2008.
sqlblog | Just another WordPress.com weblog
DMV to find out slowly running Queries. We can use DMV’s (Dynamic Management Views) to find the currently running queries in a database (and is especially handy for DBA’s ). Below is a sample query…. SELECTsqltext.TEXT,req.session id,req.status,req.command,req.cpu time,req.total elapsed time. Sysdm exec requests req. Sysdm exec sql text(sql handle) AS sqltext. October 9, 2009 at 11:42 pm. There are thousands of site which are still vulnerable to SQL Injections. Let me try to explain how this happens.
SQL Journey
This blog was created as a way for me to share some of the challenges and ideas that I have experience. June 28, 2014. Pattern Search and Replace function–Simple SQL. I have recently got a request from my insurance client to replace the non acceptable character with space in the PolicyHolder name before sending to Employers' Liability Tracing Office (ELTO). Also, it should allow a quick search incase of an investigation from ELTO. Below function has been developed with below goals in mind. SInput, N, 1 ).
Home
Skip to main content. Database Specialist Contact: Phone 02 8005 7710 Email sales@sqlbm.com. High and Detailed Level Database Infrastructure Design. Performance testing and tuning on current infrastructure to meet load demands. Advice on storage subsystem to meet IO load and budget requirements. Performance and Scalability Analysis. High end storage systems (EMC DMX, VMAX). Troubleshooting of any ongoing critical problems. Root cause analysis to any high business impact problems.
SQLBOL
SQL Server Books Online:. Microsoft SQL Server BOL Index. SQL Server 2014 Books Online. SQL Server 2012 Books Online. SQL Server 2008 R2 Books Online. SQL Server 2008 Books Online. SQL Server 2005 Books Online. SQL Server 2000 Books Online. Top Support Solutions for*:. SQL Documented Trace Flags. Events and Errors Message Center. Microsoft Assessment and Planning (MAP) Toolkit. E-Book Gallery for Microsoft Technologies.
sqlbold.com - This domain may be for sale!
Find the best information and most relevant links on all topics related to sqlbold.com. This domain may be for sale!
SQLBolt - Learn SQL - Introduction to SQL
Learn SQL with simple, interactive exercises. SQL Lesson 1: SELECT queries 101. SQL Lesson 2: Queries with constraints (Pt. 1). SQL Lesson 3: Queries with constraints (Pt. 2). SQL Lesson 4: Filtering and sorting Query results. SQL Review: Simple SELECT Queries. SQL Lesson 6: Multi-table queries with JOINs. SQL Lesson 7: OUTER JOINs. SQL Lesson 8: A short note on NULLs. SQL Lesson 9: Queries with expressions. SQL Lesson 10: Queries with aggregates (Pt. 1). SQL Lesson 11: Queries with aggregates (Pt. 2).
