Who is online?
137
guests and
0
members
Login
|
Register
home
articles
forums
blogs
did-you-know
quick tip
podcasts
files
login
about us
events
join us
write for us
newsletters
register
home
» search results
Search Results: SQL
1209 results found
How to use new Built-in Functions in
SQL
Server 2012
Microsoft SQL Server 2012 Release Candidate 0 (RC 0) introduces 14 new built-in functions. In addition to the 14 new functions, one existing function has been changed. I’ve published an article to help you understand how to use new built-in function
Author:
Sarabpreet Anand
Date: 12/6/2011 Section:
Blog
tags :
CHOOSE
,
CONCAT
,
EOMONTH
,
functions
,
IIF
,
New functions
,
SQL Server 2012
,
TRY_CONVERT
SQL
Server - Memory Shortage for all 32 Bit
SQL
Server 2012 Instances
Hi Friends, As you all know AWE has been deprecated and not available from SQL Server 2012 (Find details here ), as a result when you upgrade from SQL Server 2008 R2 to the next version of SQL Server, you cannot use more memory than what the virtual addre
Author:
Sarabpreet Anand
Date: 9/27/2012 Section:
Blog
tags :
32 Bit SQL Server 2012 Instances
,
32-bit
,
64-bit
,
awe
,
awe enabled
,
Memory Shortage
,
PAE
,
SQL Denali
,
SQL2012
,
x86
Cannot upgrade
SQL
Server Cluster as Domain groups are unavailable
I had seen a forum post and was not able reply on it. Below is a blog from my old blog which has the answer for the forum topic. Just moving this to SSG Blogs. The blog specifically talks about 2005 but the same applies for later versions. SQL Server 2005
Author:
Manohar Punna
Date: 2/26/2013 Section:
Blog
tags :
account names
,
AGTGroup
,
ASGroup
,
Cluster upgrade failure
,
Error 29528
,
FTSGroup
,
kb 925976
,
No mapping
,
Security IDs
,
SID
,
SID Mismatch
,
SQL Server
,
SQL Server 2005
,
SQLGroup
Configuring
SQL
Server 2012 Denali SSAS Engine in tabular mode
Configuring SQL Server 2012 Denali SSAS Engine in tabular mode Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named “Denali”.
Author:
Raunak Jhawar
Date: 11/22/2011 Section:
Blog
tags :
Analysis Services
,
BIDS
,
Business Intelligence
,
Excel
,
MDX
,
PASS
,
PowerPivot
,
Reporting Services
,
SQL Server 2012
,
SSAS
,
SSAS Tabular Mode
,
SSAS Tabular Project
,
UDM
SQL
Server: DB Mail Account Creation Failed - A Bug
One fine day i was configuring DB Mail on one of my server and while configuring Mail Account i encountered the following error. Error Unable to create new account SQLServerGeeks for SMTP server Microsoft.SqlServer.Management. SqlManagerUI. SQLiMailServer
Author:
Sarabpreet Anand
Date: 8/17/2011 Section:
Article
tags :
Account
,
applicable to SQLServer 2008 SP1 Standard Edition 64-bit
,
Bug
,
Database Mail
,
DB Mail
,
Profile
,
SQL Server 2008
SQL
Server Day, Mumbai, 14 April 2012 - Mumbaikars rock !!!
Hi SQL Server Geeks, This year, we kick started SQL Server Day events with great enthusiasm and aggressiveness planning events in Bangalore, Mumbai, Gurgaon & Kolkata. The first one was in Bangalore on 17 March 2012 at Microsoft campus. We blogged abo
Author:
Admin Admin
Date: 8/18/2012 Section:
Blog
tags :
SQL Server 2012 events
,
SQL Server classes
,
sql server conference
,
SQL Server events
,
SQL Server events in India
,
SQL Server seminar
,
SQL Server workshops
SQL
Server Day, Delhi NCR, 05 May 2012 - DelhiLites rock !!!
Hi SQL Server Geeks, This year, we kick started SQL Server Day events with great enthusiasm and aggressiveness planning events in Bangalore, Mumbai, Gurgaon & Kolkata. The first one was in Bangalore on 17 March 2012 at Microsoft campus. We blogged abo
Author:
Admin Admin
Date: 8/21/2012 Section:
Blog
tags :
SQL Server 2012 events
,
SQL Server classes
,
sql server conference
,
SQL Server events
,
SQL Server events in India
,
SQL Server seminar
,
SQL Server workshops
SQL
Server 2012 SEQUENCE Feature RTM restrictions and update
Hi Friends, I had written a series of blog posts on the SEQUENCE feature in DENALI (now SQL Server 2012). You can browse them here: http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/346/sql-server-2012-denali-series-sequence-object http://www.s
Author:
Amit Bansal
Date: 4/7/2012 Section:
Blog
tags :
DENALI SEQUENCE
,
SQL SERVER 2012 new features
,
SQL Server 2012 RTM
,
SQL Server 2012 SEQUENCE
,
SQL Server 2012 T SQL enhancements
SQL
Server: Implement Step by Step Contained Databases
Hi Friends, Last week, I promised to publish an article on How to Implement Contained Databases but I couldn’t, so here it is: Step-by-Step guide to Implement Contained Databases This article will explain: How to create Partially Contained Databases
Author:
Sarabpreet Anand
Date: 12/23/2011 Section:
Blog
tags :
Connect to SQL Database without Login
,
Contained Database
,
Containment
,
Create Contained database
,
Partial CDB
,
SQL Server 2012
,
SQL Server Denali
,
User with Password
,
User without Login
SQL
Server Day in Gurgaon on Feb 16 2013
Dear SQL Geek, SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And after successful events in Bangalore, Kolkata, Mumbai & Delhi NCR, we are coming again to Gurgaon. We bring you a f
Author:
Admin Admin
Date: 2/12/2013 Section:
Blog
tags :
SQL Server 2012 events
,
SQL Server classes
,
sql server conference
,
SQL Server events
,
SQL Server events in India
,
SQL Server seminar
,
SQL Server workshops
,
sqlserver
,
sqlserverday Gurgaon
SQL
Server Real-time Monitoring using WMI classes: Part -2
In the first part of this blog series, we discussed that starting with SQL Server 2005, we can use SQL Server agent to capture WMI based alerts.We can insert the alret data in to SQL Server tables and use it as needed .We took the example of Blocking and
Author:
Abhay Chaudhary
Date: 2/20/2012 Section:
Blog
tags :
1204
,
1222
,
deadlock_graph
,
deadlocks
,
deadlocks in sql server
,
monitoring
,
namespace
,
WMI
SQL
Server blogs from Ritesh Medhe for the month of February – June 2012
Hi SQL Geeks, Here are the blog posts by Ritesh Medhe for the month of February – June 2012. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at http://www.FaceBook.com/SQLServerG
Author:
Admin Admin
Date: 7/16/2012 Section:
Blog
tags :
Ritesh Medhe
SQL
Server blogs from Rakesh Mishra for the month of December
SQL Server blogs from Rakesh Mishra for the month of December Hi SQL Geeks, Here are the blog posts by Rakesh Mishra for the month of December. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs, do like us on
Author:
Admin Admin
Date: 1/5/2012 Section:
Blog
tags :
Rakesh Mishra
SQL
Server blogs from Ritesh Medhe for the month of December
SQL Server blogs from Ritesh Medhe for the month of December Hi SQL Geeks, Here are the blog posts by Ritesh Medhe for the month of December. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs, do like us on Fa
Author:
Admin Admin
Date: 1/5/2012 Section:
Blog
tags :
Ritesh Medhe
SQL
Server blogs from Amit Bansal for the month of March
Hi SQL Geeks, Here are the blog posts by Amit Bansal for the month of March. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at http://www.FaceBook.com/SQLServerGeeks Here is a summary
Author:
Admin Admin
Date: 4/1/2013 Section:
Blog
tags :
Amit Bansal
,
sql server 2012 denali
,
sql server articles
,
sql server blogs
,
sql server content
SQL
Server 2012 Denali SSIS Enhancement - Group and Connection Managers
SQL Server 2012 - Denali SSIS Enhancement Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named “Denali”. This post comes as a
Author:
Raunak Jhawar
Date: 11/18/2011 Section:
Blog
tags :
Business Intelligence
,
denali ssis new features
,
Microsoft SQL Server 2012
,
SQL Server 2012
,
SQL SERVER 2012 new features
,
SQL Server Integration Services
,
SSIS
,
SSIS new features
Memory Configuration Changes |
SQL
Server 2012
Hi Friends, Recently Microsoft introduced a few changes in SQL Server 2012 in Memory Manger, and a DBA should be aware of such changes before upgrading or installation of SQL 2012 Instance on production. In Earlier versions of SQL Server (before SQL 2012)
Author:
Sarabpreet Anand
Date: 9/27/2012 Section:
Blog
tags :
awe
,
lock pages in memory
,
max server memory
,
memory
,
memory to reserve
,
min server memory
,
multi page allocation
,
Single page allocation
,
SQL 2012
,
SQL Server Denali
,
sqlserver
SQL
Server – OPTIMIZE FOR UNKNOWN to disable parameter sniffing at query level
Hi Friends, Last week, I blogged about Trace Flag 4136: http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/663/sql-server-did-you-know-about-trace-flag-4136 and bunch of other posts related to parameter sniffing: http://www.sqlservergeeks.com/bl
Author:
Amit Bansal
Date: 10/5/2012 Section:
Blog
tags :
Disabling parameter sniffing SQL Server
,
hints SQL Server
,
query performance
,
SQL Server
SQL
Server blogs from Bhagwan Singh Jatav for the month of February – June 2012
Hi SQL Geeks, Here are the blog posts by Bhagwan Singh Jatav for the month of February – June 2012. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at http://www.FaceBook.com/SQL
Author:
Admin Admin
Date: 7/16/2012 Section:
Blog
tags :
Bhagwan Singh Jatav
SQL
Server: Performance counters used to study and analyze the current memory usage of
SQL
instance(s) to analyze memory pressure - Part 3
In this section I am going to cover, as to how we went about analyzing the performance counter values captured and then based on the results, arriving to conclusions on the new “minimum and maximum memory settings” to be proposed for the 5 SQL
Author:
Vasudev Menon
Date: 5/22/2011 Section:
Blog
tags :
Buffer cache hit ratio
,
Buffer cache hit ratio base
,
dm_os_performance_counters
,
memory pressure
,
Page life expectancy
,
performance counter
,
Stolen pages
,
Target Server Memory (KB)
,
Total Server Memory (KB)
SQL
Server blogs from Ritesh Medhe for the month of January
SQL Server blogs from Ritesh Medhe for the month of January Hi SQL Geeks, Here are the blog posts by Ritesh Medhe for the month of January. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Faceb
Author:
Admin Admin
Date: 2/1/2012 Section:
Blog
tags :
Ritesh Medhe
SQL
Server blogs from Piyush Bajaj for the month of January
SQL Server blogs from Piyush Bajaj for the month of January Hi SQL Geeks, Here are the blog posts by Piyush Bajaj for the month of January. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Faceb
Author:
Admin Admin
Date: 2/1/2012 Section:
Blog
tags :
Piyush Bajaj
SQL
Server blogs from Manohar Punna for the month of April
Hi SQL Geeks, Here are the blog posts by Manohar Punna for the month of April. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at http://www.FaceBook.com/SQLServerGeeks Here is a summa
Author:
Admin Admin
Date: 5/3/2013 Section:
Blog
tags :
manohar punna
,
sql server 2012 denali
,
sql server articles
,
sql server blogs
,
sql server content
Upgrade fails - "The Instance ID 'MS
SQL
SERVER' is already in use by
SQL
Server instance 'MS
SQL
SERVER.INACTIVE'."
This is one of the very frequent errors we receive when we try to upgrade to 2008 or 2008 R2 or to that matter even to 2005. The upgrade may fail for any reason initially and later when you fix that issue and retry to upgrade it keeps on crashing by showi
Author:
Manohar Punna
Date: 4/10/2013 Section:
Blog
tags :
Inactive instance
,
Instance ID MSSQLSERVER is already in use
,
manohar
,
manohar punna
,
Manu
,
MSSQLSERVER.INACTIVE
,
punna
,
Specify a unique instance ID
,
Sql server upgrade
,
Upgrade fails
DB-Migrate: A PowerShell Module to Migrate Databases.
Recently I wrote powershell scripts to move databases, logins and SQL Agent Jobs between instances. Another one I wrote was to fix orphan users. I have now combined all of these different functions into a single powershell module named DB-Migrate. The mod
Author:
Ahmad Osama
Date: 5/5/2013 Section:
Blog
tags :
Database Migration
,
fix orphan users
,
Move database
,
move logins
,
Move SQL Agent Jobs
,
powershell module
,
sql server migration
,
Transfer Logins
,
write to log
Page 1 of 49 (1209 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
11
...
Next >>
Go to page:
[Go]