Change the Settings of a Database Object Using Powershell
This post tells you how to change the QUOTED_IDENTIFIER and ANSI_NULLS settings of a database objects using Powershell.
Data Will Drive the World
Data and software will impact our lives more and more in the future. Steve Jones talks about some of the potential ways in which both of these have changed the world.
Red Gate Software Brings Free SQL Server Training Back to US Due to Popular Demand
Red Gate Software is bringing SQL in the City, the popular free training event, back to the US in three new cities. This October, the events will take place in Pasadena, Atlanta and Charlotte.
Uploading Data to Windows Azure SQL Database
One way of getting the advantages of the Cloud without having to migrate the entire database is to just maintain a copy of the data that needs to be accessible to internet-based users in Windows Azure SQL Database. There are various ways of keeping the two in sync, and Feodor Georgiev describes a solution based in using SSIS.
DBAs and the Fear of Time Off
Rodney Landrum on why many DBAs find it hard to ask for, and take, their due DBAcations.
Updating the TCP Port on a SQL Server Cluster Node
When installing 2 SQL Server instances on a Windows Cluster, the installation program requires a Named Instance during the installation of the second node and a dynamic TCP port is created. How do you update the TCP port after the installation in a clustered environment for the named instance?
SQL Server Sample Databases
This is a landing page for the sample SQL Server databases we are aware of.
The Job Posting - Do I really have to be the SQL God?
Looking for a job in the SQL Server industry can be a challenge for many people. Craig Farrell examines part of this process in his look at job postings and how you can interpret them.
Using source data from an SSRS report in PowerPivot for Excel
In this tip we would look using an existing SSRS report to provide the data for PowerPivot in Excel.
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCP Ngagel Jaya Selatan Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Ngagel Jaya Selatan No.25, Pucang Sewu, Kec. Gubeng, Surabaya, Jawa Timur 60283
BCA KCP Kertajaya Indah Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Manyar Kertoarjo No.95, Mojo, Kec. Gubeng, Surabaya, Jawa Timur 60285
Alamat kontak resmi BCA KCU BLITAR Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers