SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQL Rss

   Items 1 to 20 of 61    Older >>
 

Building RESTful APIs using Node JS, Express JS, and MS SQL Server

This post covers the basic details that you need to know while developing a RESTful API using Node, Express and SQL Server.  Read more...
By Manjunath Matathamana 2018/07/30 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 986 reads

Statistics not updated for the last 30 days

Find out-of-date statistics for 30 days  Read more...
By Yusuf Kahveci 2018/06/11 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 2,108 reads

Quick ADD & ALTER Generator

Generate Add & Alter columns from an existing database  Read more...
By Khaled Dev 2018/03/19 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 303 reads

Azure DWH part 27: Creating your ASDW in Cloud Shell using Bash

In this article, we will show how to create an ASDW in Bash using the Cloud Shell.  Read more...
By Daniel Calbimonte 2018/02/27 | Source: SQLServerCentral.com | Category: bash
Rating: |  Discuss |   Briefcase | 207 reads

Azure DWH part 25: Auditing and threat detection

In this new article, we will show how to audit the Data Warehouse Activities.  Read more...
By Daniel Calbimonte 2018/01/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 222 reads

Azure DWH part 23: Data Mining

SQL Server on-premises includes a module to create Data Mining models. We will show how to create them using ASDW.  Read more...
By Daniel Calbimonte 2018/01/09 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 277 reads

Shrink all user database files

Shrink all user database files  Read more...
By Khaled Dev 2017/12/29 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 363 reads

Azure DWH part 20: Create External and Internal tables As Select

CTAS and CETAS are very important T-SQL features in ASDW. These features allow to create a table and fill with data based on a query.  Read more...
By Daniel Calbimonte 2017/12/12 | Source: SQLServerCentral.com | Category: ctas
Rating: |  Discuss |   Briefcase | 319 reads

SQL-On-Hadoop: Hive - Part II

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.  Read more...
By Frank A. Banin 2017/12/11 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 698 reads

SQL Saturday statistics – Web Scraping with R and SQL Server

Tom wants to check a simple query: How many times has a particular topic been presented and from how many different presenters.  Read more...
By Additional Articles 2017/11/27 | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 3,452 reads

Missing Data

In the real world of business or scientific reporting and analysis, data can prove to be awkward. It can be plain wrong or it can be altogether missing. Sure, we have the NULL to signify unknown, but that doesn't play well with regular business reporting. There are a number of ways of dealing with missing information, and methods of estimating data from existing data has a long and respectable history. Joe Celko gets to grips with a data topic that is often treated with some trepidation.  Read more...
By Additional Articles 2017/11/13 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,888 reads

SQL Code Smells

Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there were 120 of them at the time. Phil Factor has continued to collect them and the current state of the art is reflected in this article. There are now around 150 of these smells and SQL Code Guard is committed to cover as many as possible of them.  Read more...
By Additional Articles 2017/11/06 | Source: SimpleTalk | Category: sql
Rating:  Rate this |   Briefcase | 8,046 reads

Six Scary SQL Surprises

The working life of the DBA can be punctuated by surprises, but they aren't generally nice surprises. This is especially true if the DBA is not checking and monitoring the databases for obvious things such as database corruption, and disk space. However, the really scary surprises are less obvious and provide fewer warning signs. Brent Ozar gives six scary surprises that can be avoided by the shrewd DBA.  Read more...
By Additional Articles 2017/10/31 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 6,777 reads

Azure DWH part 18: Working with SQL Server Analysis Services

In this new article, we will learn how to create a cube extracting data from ADWH.  Read more...
By Daniel Calbimonte 2017/10/09 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 327 reads

8 Ways to Export SQL Results To a Text File

This tip will show eight ways to export the results of a query to a text file.  Read more...
By Daniel Calbimonte 2017/10/06 (first published: 2016/10/26) | Source: SQLServerCentral.com | Category: export
Rating: |  Discuss |   Briefcase | 6,774 reads

Azure DWH part 17: ADF:Import Data from SQL Server on-premises to ASDW

In this article we will learn to use Data Factory to import table from SQL Server to Azure SQL Data Warehouse.  Read more...
By Daniel Calbimonte 2017/10/03 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 369 reads

Azure DWH part 16: BCP to import and export data

In Azure SQL Data Warehouse we can use BCP to export or import the data. In this article, we will show how to do it.  Read more...
By Daniel Calbimonte 2017/09/26 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 387 reads

The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data

SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to be easy for untrained people to use. Even so, there are ways of expressing SQL Queries and data manipulation in ways that make it easier for the database engine to turn into efficient action. and easier for your colleagues to understand. Robert Sheldon homes in on data querying and manipulation and makes suggestions for team standards in SQL Coding.  Read more...
By Additional Articles 2017/08/25 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,549 reads

How to Find Out Which Database Object Got Deleted

Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.  Read more...
By Additional Articles 2017/08/22 | Source: Database Journal | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,228 reads

Azure DWH part 14: PolyBase to access to Non relational data

In this article, we will learn how to work with PolyBase using Azure SQL DWH.   Read more...
By Daniel Calbimonte 2017/08/21 | Source: SQLServerCentral.com | Category: polybase
Rating: |  Discuss |   Briefcase | 520 reads
   Items 1 to 20 of 61    Older >>
 
Tags
data (18)    
azure (17)    
warehouse (15)    
server (9)    
powershell (6)    
audit (3)    
bcp (2)    
database weekly (2)    
databases (2)    
editorial (2)    
export (2)    
function (2)    
hadoop (2)    
hive (2)    
hiveql (2)    
import (2)    
mapreduce (2)    
mining (2)    
password (2)    
performance (2)    
query (2)    
reporting services (ssrs) (2)    
services (2)    
studio (2)    
add (1)    
ado (1)    
alter (1)    
analysis (1)    
backup (1)    
bash (1)    
bottlenck (1)    
c# (1)    
cetas (1)    
characters (1)    
charindex (1)    
cloud (1)    
code formatting (1)    
command (1)    
comment (1)    
copy (1)    
create (1)    
csv (1)    
ctas (1)    
data mining (1)    
database (1)    
data-driven (1)    
dba (1)    
deleted (1)    
diagrams (1)    
documentation (1)    
express (1)    
factory (1)    
files (1)    
formatting (1)    
generator (1)    
git (1)    
github (1)    
healthcheck (1)    
infographic (1)    
integration services (ssis) (1)    
interface (1)    
javascript (1)    
join (1)    
line (1)    
linux (1)    
log (1)    
migration (1)    
new (1)    
node (1)    
object (1)    
old (1)    
pal (1)    
patindex (1)    
perfmon (1)    
pivot (1)    
platform (1)    
point (1)    
polybase (1)    
productivity (1)    
profiler (1)    
prompt (1)    
recover (1)    
redgate (1)    
remote (1)    
replication (1)    
reporting (1)    
reportserver.dbo.catalog (1)    
repository (1)    
rest api (1)    
restore (1)    
script (1)    
search (1)    
shell (1)    
shrink (1)    
smo (1)    
snippets (1)    
sql login (1)    
sql prompt (1)    
sql saturday (1)    
sqlcmd (1)    
sqlserver (1)    
statistics (1)    
storage (1)    
stored procedure (1)    
substring (1)    
synch (1)    
system (1)    
task (1)    
team (1)    
text (1)    
threat (1)    
trouble shooting (1)    
t-sql (1)    
tuning (1)    
uml (1)    
unpivot (1)    
visual (1)    
vnext (1)    
xml (1)    
xpath (1)    
xquery (1)