Início > SQL Server, Virtual PASS BR > Dicas de SQL Server por PINAL DAVE (Ferramentas / Dicas e Vídeos)

Dicas de SQL Server por PINAL DAVE (Ferramentas / Dicas e Vídeos)

— Ferramentas

Link de Ferramentas

SQL SERVER – Beginning NuoDB – Who will Benefit and How to Start

SQL SERVER – Load Generator – Free Tool From CodePlex

SQL SERVER – New Look for CodePlexProject – Hosting for Open Source Software

SQL SERVER – Partition Parallelism Support in expressor 3.6

SQL SERVER – Migration Assistant for Oracle, MySQL, Sybase and Access v5.2

SQL SERVER – expressor Studio 3.4 Rules Editor – ETL Graphical Coding Tool

SQL SERVER – Introduction to expressor 3.4 Lookup Tables


— Dicas

SQL SERVER – Find First Non-Numeric Character from String

SQL SERVER – 2012 – List All The Column With Specific Data Types in Database

SQL SERVER – Basic Calculation and PEMDAS Order of Operation

SQL SERVER – Core Concepts – Elasticity, Scalability and ACID Properties – Exploring NuoDB an Elastically Scalable Database System

SQL SERVER – Grouping by Multiple Columns to Single Column as A String

SQL SERVER – Fun Post – Connecting Same SQL Server using Different Methods

SQL SERVER – DELETE, TRUNCATE and RESEED Identity

SQL SERVER – Reseting Identity Values for All Tables

SQL SERVER – Installing Data Quality Services (DQS) on SQL Server 2012

SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE  ( Parte 1 | Parte 2 )

SQL Interview Q & A

SQL Books

SQL SERVER – Beginning of SQL Server Security – Guest Post

SQL SERVER – Difference Between ORIGINAL_LOGIN() and SUSER_SNAME()

SQL SERVER – Query to Get Unique Distinct Data Based on Condition – Eliminate Duplicate Data from Resultset

SQL SERVER – Answer – How to Convert Hex to Decimal or INT

SQL SERVER – Observation of Top with Index and Order of Resultset

SQL SERVER – INFORMATION_SCHEMA.COLUMNS and Value Character Maximum Length -1

SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name – Part 2

SQL SERVER – 2012 Functions – FORMAT() and CONCAT() – An Interesting Usage

SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name

SQL SERVER – Example of Width Sensitive and Width Insensitive Collation

SQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+]

SQL SERVER – Effect of Case Sensitive Collation on Resultset

SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis

SQL SERVER – Retrieve SQL Server Installation Date Time

SQL SERVER – Monitoring SQL Server Database Transaction Log Space Growth – DBCC SQLPERF(logspace) – Puzzle for You

SQL SERVER – Discard Results After Query Execution – SSMS

SQL SERVER – Validating Spatial Object as NULL using IsNULL

SQL SERVER – Validating Spatial Object with IsValidDetailed Function

SQL SERVER – Template Browser – A Very Important and Useful Feature of SSMS

SQL SERVER – Introduction to Function SIGN

SQL SERVER – Follow up – Usage of $rowguid and $IDENTITY

SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode

SQL SERVER – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue

SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying System Tables

SQL SERVER – Read Only Files and SQL Server Management Studio (SSMS)

SQL SERVER – Simple Explanation and Puzzle with SOUNDEX Function and DIFFERENCE Function

SQL SERVER – A Puzzle – Swap Value of Column Without Case Statement

SQL SERVER – A Puzzle – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value

SQL SERVER – A Puzzle Part 2 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value

SQL SERVER – A Puzzle Part 3 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value

SQL SERVER – A Puzzle Part 4 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value

SQL SERVER – Solution of Puzzle – Swap Value of Column Without Case Statement

SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST

SQL SERVER – Finding Size of a Columnstore Index Using DMVs

SQL SERVER – Simple Example to Configure Resource Governor – Introduction to Resource Governor

SQL SERVER – SmallDateTime and Precision – A Continuous Confusion

SQL SERVER – Renaming Index – Index Naming Conventions

SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME

SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats

SQL SERVER – Developer Training Kit for SQL Server 2012

SQL SERVER – Identify Columnstore Index Usage from Execution Plan

SQL SERVER – A Tricky Question and Even Trickier Answer – Index Intersection – Partition Function

SQL SERVER – Maximum Allowable Length of Characters for Temp Objects is 116 – Guest Post by Balmukund Lakhani

SQL SERVER – A Brief Introduction to expressor Studio 3.6

SQL SERVER – Microsoft Certification – SQL Server 2012

SQL SERVER – Introduction to Discovering XML Data Type Methods – A Primer

SQL SERVER – Introduction to SQL Error Actions – A Primer

SQL SERVER – Introduction to Basics of a Query Hint – A Primer

SQL SERVER – Introduction to Hierarchical Query using a Recursive CTE – A Primer

SQL SERVER – Introduction to SQL Server Security – A Primer

SQLAuthority News – Fast Track Data Warehouse Reference Guide for SQL Server 2012

SQL SERVER – Working with FileTables in SQL Server 2012 – Part 3 – Retrieving Various FileTable Properties

SQL SERVER – Performance Tuning – Part 1 of 2 – Getting Started and Configuration

SQL SERVER – Performance Tuning – Part 2 of 2 – Analysis, Detection, Tuning and Optimizing

SQL SERVER – Working with FileTables in SQL Server 2012 – Part 1 – Setting Up Environment

SQL SERVER – Working with FileTables in SQL Server 2012 – Part 2 – Methods to Insert Data Into Table

SQL SERVER – DMV sys.dm_exec_describe_first_result_set_for_object – Describes the First Result Metadata for the Module

SQL SERVER – Use ROLL UP Clause instead of COMPUTE BY

SQL SERVER – A Puzzle – Illusion – Confusion – April Fools’ Day

SQL SERVER – sp_describe_first_result_set New System Stored Procedure in SQL Server 2012

SQL SERVER – Online Index Rebuilding Index Improvement in SQL Server 2012

SQL SERVER – Difference between DATABASEPROPERTY and DATABASEPROPERTYEX

SQL SERVER – Right Aligning Numerics in SQL Server Management Studio (SSMS)

SQL SERVER – Finding Shortest Distance between Two Shapes using Spatial Data Classes – Ramsetu or Adam’s Bridge

SQL SERVER – Install Samples Database Adventure Works for SQL Server 2012

SQL SERVER – Technical Reference Guides for Designing Mission-Critical Solutions – A Must Read

SQL SERVER – Various Leap Year Logics

SQL Server – SafePeak “Logon Trigger” Feature for Managing Data Access

SQL SERVER – Detecting Leap Year in T-SQL using SQL Server 2012 – IIF, EOMONTH and CONCAT Function

SQL SERVER – Identifying guest User using Policy Based Management

SQL SERVER – A Cool Trick – Restoring the Default SQL Server Management Studio – SSMS

SQL SERVER – guest User and MSDB Database – Enable guest User on MSDB Database

SQL SERVER – Disable Guest Account – Serious Security Issue

SQL SERVER – Solution Part 2 – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

SQL SERVER – What is Big Data – An Explanation in Simple Words

SQL SERVER – Building Interactive Reports in Quick Moments – From CSV to Excel Pivot Table – A Conversation turned to Webinar

SQL SERVER – Solution – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

SQL SERVER – INNER JOIN Returning More Records than Exists in Table

SQL SERVER – Installation Log Summary File Location – 2012 – 2008 R2

SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors

SQL SERVER – Year End Brain Teaser – Disabled Login and Associated User Without Disabled User Red Arrow

SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup

SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012

SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore

SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT Function – PRINT

SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT function

SQL SERVER – Importance of ANSI ISOLATION Levels in SQL Server Database – Quiz – Puzzle – 1 of 31

SQL SERVER – Significance of Various Kinds of Triggers- Quiz – Puzzle – 2 of 31

SQL SERVER – Understanding Identity Beyond its Every Increasing Nature – Quiz – Puzzle – 3 of 31

SQL SERVER – An Important Part of Most SELECT statement – WHERE clause – Quiz – Puzzle – 4 of 31

SQL SERVER – Locking and Blocking – Important Aspect of Database and Effect on Performance – Quiz – Puzzle – 5 of 31

SQL SERVER – Collation and Collation Sensitivity – Quiz – Puzzle – 6 of 31

SQL SERVER – Indexed Views and Restrictions – Quiz – Puzzle – 7 of 31

SQL SERVER – Using RANKING Functions Instead of SQL Looping Logic of Cursor – Quiz – Puzzle – 8 of 31

SQL SERVER – Locking, Blocking and Deadlock – Quiz – Puzzle – 9 of 31

SQL SERVER – Reasons for Using Output Clause – Quiz – Puzzle – 10 of 31

SQL SERVER – Non-Clustered Index and Automatic Rebuild – Quiz – Puzzle – 11 of 31

SQL SERVER – DACPAC and SQL Azure – Quiz – Puzzle – 12 of 31

SQL SERVER – Debate – Table Variables vs Temporary Tables – Quiz – Puzzle – 13 of 31

SQL SERVER – Cases When Stored Procedure RECOMPILE – Quiz – Puzzle – 14 of 31

SQL SERVER – Difference between CHAR, VARCHAR, NVARCHAR and VARCHAR(MAX) – Quiz – Puzzle – 15 of 31

SQL SERVER – CHECKPOINT Behavior and Database Recovery Models – Quiz – Puzzle – 16 of 31

SQL SERVER – Various Ways to Create Constraints – Quiz – Puzzle – 17 of 31

SQL SERVER – Importance of Resource Database – Quiz – Puzzle – 18 of 31

SQL SERVER – MERGE or INSERT, UPDATE, DELETE – Quiz – Puzzle – 19 of 31

SQL SERVER – Methods for Accessing SQL Server XML Datatype – Quiz – Puzzle – 20 of 31

SQL SERVER – Difference between Create Index – Drop Index – Rebuild Index – Quiz – Puzzle – 21 of 31

SQL SERVER – What is Piecemeal Restore – Quiz – Puzzle – 22 of 31

SQL SERVER – Database Mirroring and Fine-Prints – Quiz – Puzzle – 23 of 31

SQL SERVER – Correct Value for Fillfactor – Quiz – Puzzle – 24 of 31

SQL SERVER – Different Aspect of Policy Based Management – Quiz – Puzzle – 25 of 31

SQL SERVER – Common Gotcha’s Associated with Common Table Expressions (CTE) – Quiz – Puzzle – 26 of 31

SQL SERVER – Lots of Date Functions – Find Right One to Use – Quiz – Puzzle – 27 of 31

SQL SERVER – Reclaiming Space Back from Database – Quiz – Puzzle – 28 of 31

SQL SERVER – Data Collector Usage – Quiz – Puzzle – 29 of 31

SQL SERVER – Advantages of Partitioning – Quiz – Puzzle – 30 of 31

SQL SERVER – What is Slowly Changing Dimension – Quiz – Puzzle – 31 of 31

SQL SERVER – 2012 Auditing Enhancement – On Audit Log Failure Options – Maximum Rollover Files

SQL SERVER – A Quick Look at Performance – A Quick Look at Configuration

SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object

SQL SERVER – Effect of SET NOCOUNT on @@ROWCOUNT

SQL SERVER – Using expressor Composite Types to Enforce Business Rules

SQL SERVER – Powershell – Get a List of Fixed Hard Drive and Free Space on Server

SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree

SQL SERVER – Solution to Puzzle – Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function

SQL SERVER – Introduction to PERCENTILE_DISC() – Analytic Functions Introduced in SQL Server 2012

SQL SERVER – Puzzle to Win Print Book – Explain Value of PERCENTILE_CONT() Using Simple Example

SQL SERVER – Introduction to PERCENTILE_CONT() – Analytic Functions Introduced in SQL Server 2012

SQL SERVER – Introduction to PERCENT_RANK() – Analytic Functions Introduced in SQL Server 2012

SQL SERVER – Puzzle to Win Print Book – Write T-SQL Self Join Without Using LEAD and LAG

SQL SERVER – Puzzle to Win Print Book – Functions FIRST_VALUE and LAST_VALUE with OVER clause and ORDER BY

SQL SERVER – OVER clause with FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012 – ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING

SQL SERVER – Introduction to FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012

SQL SERVER – Introduction to CUME_DIST – Analytic Functions Introduced in SQL Server 2012

SQL SERVER – Updating Data in A Columnstore Index

SQL SERVER – SSMS 2012 Reset Keyboard Shortcuts to Default

SQL SERVER – Import CSV into Database – Transferring File Content into a Database Table using CSVexpress

SQL SERVER – How to Ignore Columnstore Index Usage in Query

SQL SERVER – Fundamentals of Columnstore Index

SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.

SQL SERVER – DATEDIFF – Accuracy of Various Dateparts

SQL SERVER – TRACEWRITE – Wait Type – Wait Related to Buffer and Resolution

SQL SERVER – A Simple Quiz – T-SQL Brain Trick

SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry

SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()

SQL SERVER – Quick Note about JOIN – Common Questions and Simple Answers

SQL SERVER – SQL Backup and FTP – A Quick and Handy Tool

SQL SERVER – CE – List of Information_Schema System Tables

SQL SERVER – CE – Samples Database for SQL CE 4.0

SQL SERVER – Denali – DMV – sys.dm_os_volume_stats – Information about operating system volume

SQL SERVER – Denali – DMV Enhancement – sys.dm_exec_query_stats – New Columns

SQL SERVER – Denali – Startup Parameters Easy to Configure

SQL SERVER – Denali – 14 New Functions – A Quick Guide

SQL SERVER – Denali – Date and Time Functions – EOMONTH() – A Quick Introduction

SQL SERVER – Denali – Date and Time Functions – DATEFROMPARTS() – DATETIMEFROMPARTS() – DATETIME2FROMPARTS() – TIMEFROMPARTS() – SMALLDATETIMEFROMPARTS() – DATETIMEOFFSETFROMPARTS() – A Quick Introduction

SQL SERVER – Denali – String Function – FORMAT() – A Quick Introduction

SQL SERVER – Denali – String Function – CONCAT() – A Quick Introduction

SQL SERVER – Denali – New Functions and Shorthand for CASE Statement

SQL SERVER – Denali – Logical Function – CHOOSE() – A Quick Introduction

SQL SERVER – Denali – Logical Function – IIF() – A Quick Introduction

SQL SERVER – Denali – Conversion Function – Difference between PARSE(), TRY_PARSE(), TRY_CONVERT()

SQL SERVER – Denali – Conversion Function – TRY_CONVERT() – A Quick Introduction

SQL SERVER – Denali – Conversion Function – TRY_PARSE() – A Quick Introduction

SQL SERVER – Denali – Conversion Function – PARSE() – A Quick Introduction

SQL SERVER – Use INSERT INTO … SELECT instead of Cursor

SQL SERVER – Win a Book a Day – Contest Rules – Day 0 of 35

— Erros

Resolving SQL Server Connection Errors

SQL SERVER – Get Date and Time From Current DateTime – SQL in Sixty Seconds #025 – Video

SQL SERVER – FIX ERROR – Cannot connect to . Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)

SQL SERVER – DQS Error – Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo

SQL SERVER – Error: Fix – Msg 208 – Invalid object name ‘dbo.backupset’ – Invalid object name ‘dbo.backupfile’

SQL SERVER – Fix: Error: 8117: Operand data type bit is invalid for sum operator

SQL SERVER – Fix: Error: 10920 – Cannot drop user-defined function. It is being used as a resource governor classifier

SQL SERVER – Fix: Error: 147 – An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference

SQL SERVER – – Fix Error: 8117 – A Puzzle – Fun with NULL

SQL SERVER – Fix : Error 3623 – An invalid floating point operation occurred

SQL SERVER – FIX: ERROR Msg 5169, Level 16: FILEGROWTH cannot be greater than MAXSIZE for file

SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’ as the user is currently logged in.

SQL SERVER – Case Sensitive Database and Database User – Fix: Error: 15151 – Cannot find the user , because it does not exist or you do not have permission.

SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed because this database does not have a valid owner

SQL SERVER – ERROR: FIX using Compatibility Level – Database diagram support objects cannot be installed because this database does not have a valid owner

SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped

SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.)

SQL SERVER – Explain Error:166 : does not allow specifying the database name as a prefix to the object name – Puzzle to Win SQL Server Interview Questions and Answers Book

SQL SERVER – Fix: Error: Msg 1904, Level 16 The statistics on table has 33 column names in statistics key list. The maximum limit for index or statistics key column list is 32

SQL SERVER – Fix: Error: File cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details

— Vídeos

SQL SERVER – Effect of Collation on Resultset – SQL in Sixty Seconds #026 – Video

Tricks to Replace SELECT * with Column Names – SQL in Sixty Seconds #017

SQL SERVER – 5 Videos from Joes 2 Pros Series Exam Prep Series 70-433 – SQL in Sixty Seconds

SQL SERVER – Video – Step by Step Installation of SQL Server 2012

SQL SERVER – Installing AdventureWorks Sample Database – SQL in Sixty Seconds #010 – Video

SQL SERVER – Cleaning Up SQL Server Indexes – Defragmentation, Fillfactor – Video

SQL SERVER – SQL Server Performance: Indexing Basics – SQL in Sixty Seconds #006 – Video

SQL SERVER – Powershell – Importing CSV File Into Database – Video

SQL SERVER – Function: Is Function – SQL in Sixty Seconds #004 – Video

SQL SERVER – T-SQL Constructs – *= and += – SQL in Sixty Seconds #009 – Video

SQL SERVER – Using MAXDOP 1 for Single Processor Query – SQL in Sixty Seconds #008 – Video

SQL SERVER – Table Variables and Transactions – SQL in Sixty Seconds #007 – Video

SQL SERVER – Importing CSV File Into Database – SQL in Sixty Seconds #018 – Video

SQL SERVER – Beginning Performance Tuning with SQL Server Execution Plan – Video

SQL SERVER – Tricks to Replace SELECT * with Column Names – SQL in Sixty Seconds #017 – Video

SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video

SQL SERVER – SQL in Sixty Seconds – 5 Videos from Joes 2 Pros Series – SQL Exam Prep Series 70-433

SQL SERVER – Quiz and Video – Introduction to Discovering XML Data Type Methods

SQL SERVER – Quiz and Video – Introduction to SQL Error Actions

SQL SERVER – T-SQL Errors and Reactions – Demo – SQL in Sixty Seconds #005 – Video

SQL SERVER – Quiz and Video – Introduction to Basics of a Query Hint

SQL SERVER – Quiz and Video – Introduction to Hierarchical Query using a Recursive CTE

SQL SERVER – Quiz and Video – Introduction to SQL Server Security

SQLAuthority News – Select the Best SQL in Sixty Seconds Episode – Help us Improve

SQL SERVER – Transcript of Learning SQL Server Performance: Indexing Basics – Interview of Vinod Kumar by Pinal Dave

SQL Server – Learning SQL Server Performance: Indexing Basics – Video

SQL SERVER – T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video

SQL SERVER – Be Different – Be Leader – An Interactive Journey – Questions and Answers – Book and Video

SQL SERVER – T-SQL Errors and Reactions – SQL in Sixty Seconds #002 – Video

SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video

SQL SERVER – Video – Performance Improvement in Columnstore Index

  1. Nenhum comentário ainda.
  1. No trackbacks yet.

Deixe um comentário

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s

%d blogueiros gostam disto: