Topic: SQL
New with Topic: SQL
pinaldave posted a blog entry
SQLAuthority News - SQL SERVER Database Administrator Job Description
I have previously written article about SQLAuthority News - Job Description of Database Administrator (DBA) or Database...
I have previously written article about SQLAuthority News - Job Description of Database Administrator (DBA) or Database...
pinaldave posted a blog entry
SQLAuthority Download - Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks
Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security RisksThe Windows Live...
Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security RisksThe Windows Live...
dotnetguts posted a blog entry
InStr Function in SQL Server
Visual basic support “InStr” Function, which Returns the starting position of the specified expression in a character...
Visual basic support “InStr” Function, which Returns the starting position of the specified expression in a character...
Thomas L posted a blog entry
Lots of databases, full recovery model, low disk space...what to do?
I do not much care for having my development databases set to Recovery modell = full. There is really no need for that. The day...
I do not much care for having my development databases set to Recovery modell = full. There is really no need for that. The day...
Rob B shared an item
SQL Server 2008 Filtered Indexes vs Index Views
SQL Server 2008 has a new feature called filtered indexes which are like normal table indexes only they have a simple where clause, meaning that the index will only cover rows specified in the where clause. As I have mentioned before an obvious example...
SQL Server 2008 has a new feature called filtered indexes which are like normal table indexes only they have a simple where clause, meaning that the index will only cover rows specified in the where clause. As I have mentioned before an obvious example...
3 hours ago
Google Reader
| Topics: Performance, SQL Server..., SQL | Add google reader to your profile
Google Reader
| Topics: Performance, SQL Server..., SQL | Add google reader to your profile
Bradley Woods bookmarked a link
SQL Server 2005 - how to use it
This page is a compilation of information about SQL Server 2005
This page is a compilation of information about SQL Server 2005
Mad Goldfish bookmarked a link
Testing Times Ahead: Extending NUnit
Extend NUnit to include SQL testing and SQL injection pre- and post-test
Extend NUnit to include SQL testing and SQL injection pre- and post-test
4 hours ago
Delicious
| Topics: .net, database, development, extending | Add delicious to your profile
Delicious
| Topics: .net, database, development, extending | Add delicious to your profile
Cristian C posted a blog entry
Index Organized Tables
Continua per me un periodo intenso che mi impedisce di scrivere con la regolarità che vorrei su questo blog. Gli impegni del...
Continua per me un periodo intenso che mi impedisce di scrivere con la regolarità che vorrei su questo blog. Gli impegni del...
pinaldave posted a blog entry
SQL SERVER - Ideal TempDB FileGrowth Value
Just a day ago, while installing SQL Server on our development machine Jr. DBA asked me what should be kept file growth of the...
Just a day ago, while installing SQL Server on our development machine Jr. DBA asked me what should be kept file growth of the...
13 hours ago
Journey to SQL Authority with Pinal Dave
| Topics: Author Pinal, SQL, SQL Authority, SQL...
Journey to SQL Authority with Pinal Dave
| Topics: Author Pinal, SQL, SQL Authority, SQL...
Tuuli bookmarked a link
20 hours ago
Delicious
| Topics: documentation, postgresql, programming, reference | Add delicious to your profile
Delicious
| Topics: documentation, postgresql, programming, reference | Add delicious to your profile
philbenwell posted a blog entry
SQL isn’t so scary after all
I have had this thing in my head from quite some time about learning SQL and thinking that it was going to be impossible for...
I have had this thing in my head from quite some time about learning SQL and thinking that it was going to be impossible for...
Ido posted a blog entry
SQL injections in web applications
It is one of the most common and painful security holes.Any web site that use a database (even if it's for read only!) might...
It is one of the most common and painful security holes.Any web site that use a database (even if it's for read only!) might...
Mirza Safiullah Baig tagged
Best Host Online community as Verisign, SSL, SSN, cj, commission junction, CJU, google, analytics, Google+Analytics, wireless, IBM, The planet, eapps, JSP, Servlets, SQL, MySQL, Mssql, struts, xml, XML Web Services, Free Web Hosting, Free Web Hosts
1 day ago
MyBlogLog Action
MyBlogLog Action
pinaldave posted a blog entry
SQL SERVER - Find Table in Every Database of SQL Server - Part 3
Previously I wrote two articles about SQL SERVER - Find Table in Every Database of SQL ServerSQL SERVER - Find Table in Every...
Previously I wrote two articles about SQL SERVER - Find Table in Every Database of SQL ServerSQL SERVER - Find Table in Every...
smilu v posted a blog entry
SQL Transactions in .net
SqlTransaction is used in cases we are updating Multiple tables at a Time. Here the error occurs such as first table gets...
SqlTransaction is used in cases we are updating Multiple tables at a Time. Here the error occurs such as first table gets...
pinaldave posted a blog entry
SQL SERVER - Four Basic SQL Statements - SQL Operations
There are four basic SQL Operations or SQL Statements.SELECT - This statement selects data from database tables.UPDATE - This...
There are four basic SQL Operations or SQL Statements.SELECT - This statement selects data from database tables.UPDATE - This...
2 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Author Pinal, Database, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: Author Pinal, Database, SQL, SQL Authoritypinaldave posted a blog entry
SQL SERVER - Orphaned MS DTC Transaction Information
Few days ago, one of our application was crashing IIS application pool because of unhandled exception. After researched we...
Few days ago, one of our application was crashing IIS application pool because of unhandled exception. After researched we...
2 days ago
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL..., SQL Error...
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL..., SQL Error...pinaldave posted a blog entry
SQL SERVER - SQL Joke, SQL Humor, SQL Laugh - Silly Mistake
It is really very bad of person to laugh on others misfortune, however dark humor is based on the same concept. It has been...
It is really very bad of person to laugh on others misfortune, however dark humor is based on the same concept. It has been...
englishteeth posted a blog entry
Grails on an existing database
The usual grails approach is to create the database to reflect the model, but if there is an existing database there a few...
The usual grails approach is to create the database to reflect the model, but if there is an existing database there a few...
Jeff posted a blog entry
Convert a Drupal Site to Wordpress
One of my sites used to be Drupal 5.x. I recently decided that it was time to convert the site to Wordpress 2.5.x. The reason...
One of my sites used to be Drupal 5.x. I recently decided that it was time to convert the site to Wordpress 2.5.x. The reason...
KarmaMule bookmarked a link
Common Table Expressions (CTE's) - How it works; How Recursion Works; Using with Adjacency List - Tony Rogerson's ramblings on SQL Server
Overview of CTEs, especially in conjunction with recursive techniques
Overview of CTEs, especially in conjunction with recursive techniques
joeyc00lit P bookmarked a link
3 days ago
Delicious
| Topics: Database, Microsoft, Performanc..., SQL | Add delicious to your profile
Delicious
| Topics: Database, Microsoft, Performanc..., SQL | Add delicious to your profile
Peter bookmarked a link
3 days ago
Delicious
| Topics: articles, comparison, computer, database | Add delicious to your profile
Delicious
| Topics: articles, comparison, computer, database | Add delicious to your profile
cheeaun bookmarked a link
SQL Buddy - Web based MySQL administration
prettier and cleaner than phpMyAdmin
prettier and cleaner than phpMyAdmin
pinaldave posted a blog entry
SQL SERVER 2005 - Microsoft Will Release SP3 Soon
I have received quite a few inquires if Microsoft is going to release SP3 for SQL Server or not?Yes! Microsoft is going to...
I have received quite a few inquires if Microsoft is going to release SP3 for SQL Server or not?Yes! Microsoft is going to...
4 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Database, SQL, SQL Add-On, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: Database, SQL, SQL Add-On, SQL Authority
ReallyVirtual posted a blog entry
Your Privacy is an Illusion
What would you do if your laundry-shop published your laundry bills online, along with your name, address and phone number, for...
What would you do if your laundry-shop published your laundry bills online, along with your name, address and phone number, for...
FLSEO bookmarked a link
5 days ago
Delicious
| Topics: coldfusion, programming, queryofquery, sql | Add delicious to your profile
Delicious
| Topics: coldfusion, programming, queryofquery, sql | Add delicious to your profile
pinaldave posted a blog entry
SQL SERVER - 2005 - Find Tables With Foreign Key Constraint in Database - Part 2
What I love most about this blog is active readers participation. If readers are becoming contributor is the true success for...
What I love most about this blog is active readers participation. If readers are becoming contributor is the true success for...
5 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Author Pinal, SQL, SQL Authority, SQL Constraint and...
Journey to SQL Authority with Pinal Dave
| Topics: Author Pinal, SQL, SQL Authority, SQL Constraint and...pinaldave posted a blog entry
SQL SERVER - FIX : Error 7311 - You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server
Following email is received from SQL Server Expert Roy Cheung. He faced issue of creating and running distributed queries from...
Following email is received from SQL Server Expert Roy Cheung. He faced issue of creating and running distributed queries from...
5 days ago
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL Error..., SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL Error..., SQL Querypinaldave posted a blog entry
SQL SERVER - Function Property - Deterministic or Non-Deterministic
I recently received question through email that how to determine if any user defined function is deterministic or...
I recently received question through email that how to determine if any user defined function is deterministic or...
5 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Author Pinal, SQL, SQL Authority, SQL Function
Journey to SQL Authority with Pinal Dave
| Topics: Author Pinal, SQL, SQL Authority, SQL FunctionRelated topics
Author Pinal
database
dba
development
MySQL
.net
phpMyAdmin
programming
reference
SQL Authority
SQL Query
sqlserver
SQL Tips and Tricks
technology
T-SQL
Top members tagged
Top communities tagged
