September 19, 2011 at 4:33 am
ALZDBA (9/18/2011)
SQLRNNR (9/18/2011)
ALZDBA (9/18/2011)
Lynn Pettis (9/18/2011)
bitbucket-25253 (9/17/2011)
Ninja's_RGR'us (9/17/2011)
Hey guys (als), I just got a bank offer for a 70% / 30% sql svr / oracle environement.Now all I know about Oracle is how to speel it (and barely at that).
How hard is it to pick it up on the spot? The job seems to range from installing, to configuring, perf tuning to HA on both platforms.
Sounds like a lot to pick on the spot without and excellent mentor or full 100% responsibility split.
Talk with Lynn Pettis and/or follow his blog here a SCC
http://www.sqlservercentral.com/blogs/lynnpettis/
By Lynn Pettis in SQL Musings from the Desert 08-26-2010 10:15 PM | Categories: Filed under: Oracle
More importantly, I am getting exposed to the “O” word, yes, Oracle, and will be working with both Oracle 8 and Oracle 10.
And more importantly that I am now BACK in the SQL Server world. Oracle is the dark side, things we can easily do in SQL Server are not that easily done over there. Not only that the Oracle community for the most part is very stingy with their knowledge. It is nothing like the SQL Server community where we welcome the opportunity to share our knowledge and experience with others.
IMO that tells more about the people than the engine of their concerns.
It's a cultural problem, just like the fact companies accept to spend more budget to that software to twist some nuts and bolts.
I love our community, but I'm jealous about that kind of easy budget !
Interesting choice of words. I was just thinking that Oracle had those companies by the nuts and bolts.
😀
I've only begun supporting Oracle last year. Learning won't be as fast as ms sql server because a lot of functionality is third-party or enterprise edition only (etl, replication...).
Capturing the basics goes fast (how it works, backup/restore), tuning/monitoring is another matter. Still struggling with the enterprise manager (replacement for management studio) that won't install properly. Tools: sqlplus, gui: toad/dbvisualizer/...
Have a look at Oracle forums if you need help.
September 19, 2011 at 4:34 am
jcrawf02 (9/16/2011)
btw, PM'd you last week. Feel free to ignore me, but didn't know if you just missed it.
We had an upgrade and I was ignoring the site for a week, so I probably missed it. I'll go back and check today once I get my morning checklist completed.
September 19, 2011 at 5:31 am
Opinions wanted: Is it fair to post a Denali solution?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 19, 2011 at 5:47 am
WayneS (9/19/2011)
Opinions wanted: Is it fair to post a Denali solution?
Fair but slow, based on your performance tests.
-- Gianluca Sartori
September 19, 2011 at 5:57 am
GSquared (9/16/2011)
Brandie Tarvin (9/16/2011)
I'm thinking about getting a tablet so I can do email & social networking apps while I am at functions (rather than lugging my laptop around), but also read books on it. Therefore, I went to look at the Nook Color today, but I'm still not convinced this is my best choice. The problem with the Nook Color is that it requires logging on to WiFi. I want to be able to log onto the internet even when there is no WiFi available (via use of a broadband card, etc.).Anyone have any good options / advice on the matter?
If you want one with a full-on Internet connection, get one with built in 3G/4G, don't get one with WiFi and get a tethering device. You'll save money in the long run. You'll be tied to a connection provider (Verizon is what I'd recommend, because they have the fastest network for this), but that should be okay. (Changing providers will mean buying a new tablet, so be sure you're okay with the one you start with.)
I have a WiFi-only Galaxy 10.1, 16 Gig version, Android 3.2. Totally rocks.
I haven't had trouble finding WiFi hotspots, and I plan to get a phone I can tether through reasonable soon for those few times I need a connection and can't just find one. One data plan, for the phone, is cheaper than a 3G/4G tablet with its own data plan, and I don't download movies, so I'm not worried about the big bandwidth uses that would make a separate plan useful.
Okay, let's talk tethering. Let's say I get a smart phone (requires me to get off iDen if I want a decent smart phone). What's security like with tethering?
I know with WiFi, your traffic can be intercepted quite easily, especially if you make the mistake of logging into some data thief's faux connection. How does security for tethering work to prevent that sort of data interception?
September 19, 2011 at 6:24 am
Gianluca Sartori (9/19/2011)
WayneS (9/19/2011)
Opinions wanted: Is it fair to post a Denali solution?Fair but slow, based on your performance tests.
Slow compared to QU, but still faster than c.u.r.s.o.r.
Maybe I ought to do some comparison tests with Hugo's set-based methods, and others that come out of this challenge.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 19, 2011 at 6:29 am
GilaMonster (9/18/2011)
For some general silliness...
CREATE DATABASE [Oops]ON PRIMARY (
NAME = N'Oops', FILENAME = N'D:\Develop\Databases\Oops.txt:Data'
)
LOG ON (
NAME = N'Oops_log', FILENAME = N'D:\Develop\Databases\Oops.txt:Log'
)
GO
Data files, what data files? And where did the log go?
ME LIKE!!!!
Gail, you are officially evil, in all the right ways!
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 19, 2011 at 6:37 am
Brandie Tarvin (9/19/2011)
GSquared (9/16/2011)
Brandie Tarvin (9/16/2011)
I'm thinking about getting a tablet so I can do email & social networking apps while I am at functions (rather than lugging my laptop around), but also read books on it. Therefore, I went to look at the Nook Color today, but I'm still not convinced this is my best choice. The problem with the Nook Color is that it requires logging on to WiFi. I want to be able to log onto the internet even when there is no WiFi available (via use of a broadband card, etc.).Anyone have any good options / advice on the matter?
If you want one with a full-on Internet connection, get one with built in 3G/4G, don't get one with WiFi and get a tethering device. You'll save money in the long run. You'll be tied to a connection provider (Verizon is what I'd recommend, because they have the fastest network for this), but that should be okay. (Changing providers will mean buying a new tablet, so be sure you're okay with the one you start with.)
I have a WiFi-only Galaxy 10.1, 16 Gig version, Android 3.2. Totally rocks.
I haven't had trouble finding WiFi hotspots, and I plan to get a phone I can tether through reasonable soon for those few times I need a connection and can't just find one. One data plan, for the phone, is cheaper than a 3G/4G tablet with its own data plan, and I don't download movies, so I'm not worried about the big bandwidth uses that would make a separate plan useful.
Okay, let's talk tethering. Let's say I get a smart phone (requires me to get off iDen if I want a decent smart phone). What's security like with tethering?
I know with WiFi, your traffic can be intercepted quite easily, especially if you make the mistake of logging into some data thief's faux connection. How does security for tethering work to prevent that sort of data interception?
You can secure it with WEP, WPA, or WPA2. WEP is encrypted, but pretty easy to break. WPA has been broken, but it's harder. WPA2 uses AES/CCMP encryption and is reasonably secure. WEP and WPA are bother considered obsolete, and WPA2 has been the required standard for WiFi certification since 2006.
You can also use HTTPS or VPN in the connection, but that's harder to set up. (I really can't see setting up a smartphone as a VPN access point, but it's probably possible.)
I'd just set up WPA2, exercise the usual security consciousness in what you do with the tablet, and call it good enough.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 19, 2011 at 6:55 am
GilaMonster (9/18/2011)
For some general silliness...
CREATE DATABASE [Oops]ON PRIMARY (
NAME = N'Oops', FILENAME = N'D:\Develop\Databases\Oops.txt:Data'
)
LOG ON (
NAME = N'Oops_log', FILENAME = N'D:\Develop\Databases\Oops.txt:Log'
)
GO
Data files, what data files? And where did the log go?
(Banging head on desk for my lack on understanding...)
Huh?
(Please allmighty THREAD, pardon me for the code I'm about to post in your domain...)
I tried:
USE master;
GO
IF DB_ID('Oops') IS NOT NULL DROP DATABASE [Oops];
GO
CREATE DATABASE [Oops]
ON PRIMARY (
NAME = N'Oops', FILENAME = N'C:\Temp\Oops.txt:Data'
)
LOG ON (
NAME = N'Oops_log', FILENAME = N'C:\Temp\Oops.txt:Log'
)
GO
ALTER DATABASE [Oops] SET RECOVERY SIMPLE;
GO
USE [Oops];
GO
;WITH
TENS (N) AS (SELECT 0 UNION ALL SELECT 0 UNION ALL SELECT 0 UNION ALL
SELECT 0 UNION ALL SELECT 0 UNION ALL SELECT 0 UNION ALL
SELECT 0 UNION ALL SELECT 0 UNION ALL SELECT 0 UNION ALL SELECT 0),
THOUSANDS (N) AS (SELECT 1 FROM TENS t1 CROSS JOIN TENS t2 CROSS JOIN TENS t3),
MILLIONS (N) AS (SELECT 1 FROM THOUSANDS t1 CROSS JOIN THOUSANDS t2),
TALLY (N) AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 0)) FROM MILLIONS)
SELECT N
INTO [Oops].dbo.Tally
FROM TALLY
ORDER BY N;
GO
CHECKPOINT;
GO
SELECT * FROM sys.database_files;
GO
USE master;
GO
--DROP TABLE tally
--EXEC master.dbo.sp_detach_db @dbname = N'Oops'
GO
SELECT TOP (100) N FROM [Oops].dbo.Tally;
GO
The Oops.txt file is EMPTY???? (At least Windows Explorer shows it to be 0 bytes, so this is consistent.)
If you don't run the detach, you can see the table in SSMS.
Gail, you are truly evil!!! (I love it! - now, I just need to understand what is going on!)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 19, 2011 at 7:06 am
WayneS (9/19/2011)
The Oops.txt file is EMPTY???? (At least Windows Explorer shows it to be 0 bytes, so this is consistent.)If you don't run the detach, you can see the table in SSMS.
Gail, you are truly evil!!! (I love it! - now, I just need to understand what is going on!)
I believe that is using NTFS Streams which hide the file from the OS...
September 19, 2011 at 7:16 am
WayneS (9/19/2011)
The Oops.txt file is EMPTY???? (At least Windows Explorer shows it to be 0 bytes, so this is consistent.)
Yes it is. If you take the DB offline or stop SQL you can edit it. Great for documenting the DB. 😀
Editing the text file will not harm the DB in any way.
(I love it! - now, I just need to understand what is going on!)
NTFS alternate streams. The data and log files are both alternate streams of that text file. Explorer doesn't show alternate streams (weakness of the tool, nothing more). I believe sysinternals or MS has a tool Streams.exe that can show you the alternate streams on a file.
CheckDB uses alternate streams by default. It creates a database snapshot and puts the snapshot files as alternate streams of the mdf and ndf(s). That's why you can get checkDB errors like this:
Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "A database snapshot cannot be created because it failed to start.
Write to sparse file 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\MSDBData.mdf:MSSQL_DBCC7' failed due to lack of disk space.
There's no good or practical reason to do what I showed, it's near-impossible to understand and it will break CheckDB. (Can't create an alternate stream of an alternate stream)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 19, 2011 at 7:18 am
p.s. http://support.microsoft.com/kb/105763
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 19, 2011 at 7:33 am
GilaMonster (9/19/2011)
There's no good or practical reason to do what I showed, it's near-impossible to understand and it will break CheckDB. (Can't create an alternate stream of an alternate stream)
Sounds like a good QotD coming up - why doesn't CheckDB work with this database?
Thanks for the explanation - I haven't saw streams directly used before, wasn't sure what that syntax was doing. Very interesting.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 19, 2011 at 7:40 am
WayneS (9/19/2011)
GilaMonster (9/19/2011)
There's no good or practical reason to do what I showed, it's near-impossible to understand and it will break CheckDB. (Can't create an alternate stream of an alternate stream)Sounds like a good QotD coming up - why doesn't CheckDB work with this database?
No, I don't think so. It's nothing more than a silly trick with no practical use.
CheckDB does work, providing it can get the locks for an offline check. The snapshot creation fails so it can't run online.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 19, 2011 at 8:16 am
GilaMonster (9/16/2011)
The checkpoint does not write dirty pages to the log file. It writes them to the data file as long as the associated log records have been hardened in the data file.
Aiaiai! Ron and I had a discussion on this just a couple weeks ago (here). I was having a hard time figuring out when/why a checkpoint would write out dirty log pages, but ended up closing my question when I found a line in the 2K8 internals book stating that it did in fact write out dirty log pages (p.183). It seemed that transactions in progress may in fact have log information that wasn't hardened yet, is that not so?
Thanks,
Chad
Viewing 15 posts - 30,046 through 30,060 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply